Database snapshots do not work well with databases having multiple log files
Posted By: Posted Date: September 24, 2010
Points: 0 Category :Sql Server
It appears there is a bug in the implementation of database snapshots.
If you create a snapshot on a database with multiple log files:
CREATE DATABASE MYDB_ss1000 ON (NAME = MYDB_DB_GROUP2FILE1, FILENAME = 'D:\Restore\MYDB_DB_GROUP2FILE1_1000.ss')
, (NAME = MYDB_DB_GROUP2FILE2, FILENAME = 'D:\Restore\MYDB_DB_GROUP2FILE2_1000.ss')
, (NAME = MYDB_DB_GROUP3FILE1, FILENAME = 'D:\Restore\MYDB_DB_GROUP3FILE1_1000.ss')
, (NAME = MYDB_DB_GROUP3FILE2, FILENAME = 'D:\Restore\MYDB_DB_GROUP3FILE2_1000.ss')
, (NAME = MYDB_DB_PRIMARY1, FILENAME = 'D:\Restore\MYDB_DB_PRIMARY1_1000.ss')
, (NAME = MYDB_DB_PRIMARY2, FILENAME = 'D:\Restore\MYDB_DB_PRIMARY2_1000.ss') AS SNAPSHOT OF MYDB
Then restore from the snapshot:
RESTORE DATABASE MYDB FROM DATABASE_SNAPSHOT = 'MYDB_ss1000'
then all of you log files, but one will disappear. As a result the backup command will fail with the following message:
Msg 3636, Level 16, State 2, Line 1
An error occurred while processing 'BackupMetadata' metadata for database id 12 file id 10.
Msg 3046, Level 16, State 2, Line 1
Inconsistent metadata has been encountered. The on
View Complete Post
More Related Resource Links