1.
RESTORE DATABASE [pubs] FROM DISK = N'C:\backup\model.bak'
WITH FILE = 1, RECOVERY, REPLACE, KEEP_REPLICATION,
MOVE N'modeldev' TO N'C:\Program Files\Microsoft SQL Server\MSSQL\data\pubs_Playback.mdf',
MOVE N'modellog' TO N'C:\Program Files\Microsoft SQL Server\MSSQL\data\pubs_Playback.ldf'
2.
RESTORE DATABASE [pubs] FROM DISK = N'C:\backup\pubs.bak'
WITH STATS=10, FILE = 1, RECOVERY, REPLACE, KEEP_REPLICATION,
MOVE N'pubs' TO N'C:\Program Files\Microsoft SQL Server\MSSQL\data\pubs.mdf',
MOVE N'pubs_log' TO N'C:\Program Files\Microsoft SQL Server\MSSQL\data\pubs_log.ldf'
I dont understand what role the first SQL statement plays.
Or the original code has problem?If you are running these two statements right after one another with nothing in between, then I would say the first statement is useless. I'm not sure why you would recover a backup of the model database into the pubs database and then restore a backup of the pubs database into pubs. I notice it has the KEEP_REPLICATION setting on, but I don't see how that would alter things. Anyone else?
No comments:
Post a Comment