:::: MENU ::::

Posts Categorized / System Databases

  • Apr 02 / 2009
  • 0
Backup and Restore, DBA Interview questions, dbDigger, System Databases, Troubleshooting

Cannot back up the log of the master database. Use BACKUP DATABASE instead.

The error message
Msg 4212, Level 16, State 1, Line 2
Cannot back up the log of the master database. Use BACKUP DATABASE instead.
is error of severity level 16 and can occur on all versions of SQL Server. It appears when you try to backup log of master database. SQL Server does not allow to backup log of master database. To avoid the error you should take full backup of master database.

  • Nov 21 / 2008
  • 0
Backup and Restore, dbDigger, System Databases

How do you restore the master database on a SQL Server cluster?

Use following steps for SQL Server 7.0 and SQL Server 2000 to restore the master database on a SQL Server cluster

  1. Identify which node SQL Server is currently running on, such as node1.
  2. From Cluster Administrator, take the SQL Server resources off-line.
  3. Go to the node running SQL Server (see step 1) and start it from the command prompt using:

    sqlservr.exe -c -m

  4. Restore the master database using Query Analyzer or Enterprise Manager.
  5. Quit SQL Server from the command prompt.
  6. Using Cluster Administrator, restart the SQL Server services.

FROM SQL-Server-Performance.com

Consult us to explore the Databases. Contact us