Sunday, March 11, 2012

Backup Database

Hi all,
I wanna Format my database server due to some reason...
so how i can Backup of SQL Server Databases...
i have around 25 Databases in Sql Server.. and i wanna take backup of all..
So how i can perform this task..
plz guide Step by step...
i m new in DataBase Backup ..... ;)
Thanx
SajjadGolden Rule number 1 - protect the data

If you have no Backup regime in place I suggest you create one - sharpish.
Then practice restoring the backups.

Create a New Maintanence plan under Management in EM (right click Maint Plans)

Create a new DB and backup then delete - re create the DB right click it and restore from Device - point device to .bak file.

Make sure you have all the logins recorded

GW|||You have 25 databases and NO BACKUPS?

Either get a DBA, or become a DBA, very fast. You can start by reading Books Online, which covers backups, log dumps, and everything else you need to know.|||thanx for reply,,
plz give some link of DBA books or give web address for this
thanx
Sajjad|||thanx for reply,,
plz give some link of DBA books or give web address for this
thanx
Sajjad
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.mspx|||Books Online should have been installed with SQL Server by default. It should be in your Start menu along with SQL Server Enterprise Manager.

No comments:

Post a Comment