This entry was posted in Internals, SQLServerPedia Syndication and tagged backup, internals, restore, sql 2000, sql 2005, sql 2008, system databases on Augby PradeepAdiga. To minimize the risk of catastrophic data loss, you need to back up your databases to preserve modifications to your data on a regular basis. Moral of the story is you can only take FULL backup of master database. The SQL Server backup and restore component provides an essential safeguard for protecting critical data stored in your SQL Server databases. Master database has to be in Recovered status always. 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. While researching this article I was surprised by the number of DBAs who back up their user. Open SSMS and the backup option looks like this. Restoring the SQL Server Master Database Even Without a Backup. Why not try taking the differential backup of master database instead. “ Is it possible to take the differential backup of master database?”.
0 kommentar(er)
