This is a multi-part message in MIME format.
--=_NextPart_000_0099_01C58847.15C5D770
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi,
Is there a way to backup database every week and the restore a = particular week's database.
Thanks
Kiran
--=_NextPart_000_0099_01C58847.15C5D770
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Hi,
Is there a way to backup database every = week and the restore a particular week's database.
Thanks
Kiran
--=_NextPart_000_0099_01C58847.15C5D770--Of course. have you looked at Backup and Restore T-SQL commands and topics
about Scheduled Jobs in Books OnLine?
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
Showing posts with label format. Show all posts
Showing posts with label format. Show all posts
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.
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.
Subscribe to:
Posts (Atom)