This entry was posted in Internals, SQLServerPedia Syndication and tagged backup, internals, restore, sql 2000, sql 2005, sql 2008, system databases on Augby PradeepAdiga. Moral of the story is you can only take FULL backup of master database. Master database has to be in Recovered status always. In SQL Backup Master’s main window, navigate to the Backup and Restore tab and select the New Backup button. But SQL Server does not allow master database to be restored without recovery. It is confirmed that SQL Server is designed to allow only FULL backup of master database.īut why? For differential backups to be applied on a database, the database has to be in NORECOVERY ( Recovering) state. You can only perform a full backup of the master database. Let us try out the script to take the differential backup of master database. So SQL Server does not allow any other type of backup operation to be performed on master database. Open SSMS and the backup option looks like this. Why not try taking the differential backup of master database instead. “ Is it possible to take the differential backup of master database?”.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |