:::: MENU ::::

Posts Categorized / Backup and Restore

  • 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.

  • Feb 12 / 2009
  • 0
Backup and Restore, dbDigger, SSMS tips and tricks

how to restore SQL Server backup through SQL Server management Studio(SSMS)

Microsoft has introduced SQL Server Management Studio (SSMS) with SQL Server 2005 release. It is now a favorite tool of SQL Server DBAs. Most of new DBAs and students that are new to SQL Server feel a bit confusion to adopt various facilities for tasks provided in SSMS. I have sketched a step by step configuration for some basic tasks through SSMS.
In this post we will see how to restore SQL Server backup through SQL Server management Studio(SSMS). Follow these steps in your SSMS

Restore SQL Server Database-1

Restore SQL Server Database-2

 

Restore SQL Server Database-3

 

Restore SQL Server Database-4

 

Restore SQL Server Database-5

 

Restore SQL Server Database-6

 

If database already exists then set the option to overwrite it. Make sure that the path you are providing for files in valid path.

 

Restore SQL Server Database-7

 

Click Ok to start restore operation.

  • Jan 27 / 2009
  • 0
Backup and Restore, dbDigger, SSMS tips and tricks

Backup SQL Server database through SQL Server Management Studio (SSMS)

Microsoft has introduced SQL Server Management Studio (SSMS) with SQL Server 2005 release. It is now a favorite tool of SQL Server DBAs. Most of new DBAs and students that are new to SQL Server feel a bit confusion to adopt various facilities for tasks provided in SSMS. I have sketched a step by step configuration for some basic tasks through SSMS.
In this post we will see how to backup a database through SSMS. Follow these steps in your SSMS

Backup SQL Server Database-1

 

Backup SQL Server Database-2

 

Backup SQL Server Database-3

 

Backup SQL Server Database-4

 

Backup SQL Server Database-5

 

Click Ok and backup process will be started.

  • Jan 27 / 2009
  • 1
Backup and Restore, dbDigger, SSMS tips and tricks

Attaching SQL Server database through SQL Server Management Studio (SSMS)

Microsoft has introduced SQL Server Management Studio (SSMS) with SQL Server 2005 release. It is now a favorite tool of SQL Server DBAs. Most of new DBAs and students that are new to SQL Server feel a bit confusion to adopt various facilities for tasks provided in SSMS. I have sketched a step by step configuration for some basic tasks through SSMS.
In this post we will see how to attach a database through SSMS. Follow these steps in your SSMS

Attach SQL Server Database-1

 

Attach SQL Server Database-2

 

Attach SQL Server Database-3

 

Attach SQL Server Database-4

 

Then click OK to start the attach process.

  • 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

Pages:1234
Consult us to explore the Databases. Contact us