If the backup file is ok then you can continue with shutting down the database and ensuring nobody else accesses the database: USE MASTERĪLTER DATABASE DBASE SET OFFLINE WITH ROLLBACK IMMEDIATE Has been enhanced to do additional checking on the data to increase the In Microsoft SQL Server, RESTORE VERIFYONLY RESTORE VERIFYONLY does not attempt to verify the structure of the dataĬontained in the backup volumes.
Verifies the backup but does not restore it, and checks to see that theīackup set is complete and the entire backup is readable. restore verifyonly from disk = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.DBASE\MSSQL\Restore\DBASE.BAK' returns a result set containing all the backup header information for all backup sets on a particular backup device.
I'd start with verifying the backup file using the following statements: restore headeronly from disk = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.DBASE\MSSQL\Restore\DBASE.BAK' Can someone please tell me how I can restore my database with a BAK file using a SQL query?
I don't want to restore the master database. (Error 3102) RESTORE DATABASE is terminating abnormally. It is recommended that the master database be used when performing this operation. RESTORE cannot process database 'DBASE' because it is in use by this session. When I run the query I get the following error:Įxecuted as user: NT AUTHORITY\SYSTEM. MOVE 'DBASE' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.DBASE\MSSQL\DATA\DBASE_2.LDF' MOVE 'DBASE' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.DBASE\MSSQL\DATA\DBASE_1.LDF', MOVE 'DBASE' TO 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.DBASE\MSSQL\DATA\DBASE.MDF', I am trying to restore that backup, but I unable to do so.įROM DISK = 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.DBASE\MSSQL\Restore\DBASE.BAK' I have my database backing up to the hard disk in the format of BAK file.
0 kommentar(er)
