Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

database backup Expand / Collapse
Author
Message
Posted Wednesday, November 14, 2007 3:51 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, September 12, 2008 2:36 AM
Points: 230, Visits: 31
HI,

How to back up the database in sqlserver2000

Regards.
karthikeyan..
Post #422013
Posted Wednesday, November 14, 2007 4:51 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, November 7, 2014 9:20 AM
Points: 2,555, Visits: 607
Karthikeyan - your first stop should be Books Online - it has a wealth of information - you will be backing up databases in no time at all with a 5 minute dekko...:)







**ASCII stupid question, get a stupid ANSI !!!**
Post #422037
Posted Wednesday, November 14, 2007 5:01 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 20, 2011 8:59 AM
Points: 269, Visits: 108
Backup database 'dbname' to disk = 'C:\pathname'

is the basic why but I would look on BOL for the extras like the different type of backups, adding backup devices
Post #422040
Posted Wednesday, November 14, 2007 7:27 PM


Keeper of the Duck

Keeper of the Duck

Group: Moderators
Last Login: Friday, November 14, 2014 7:14 AM
Points: 6,625, Visits: 1,876
Alternately, if you are in a rush and have to get the job done, Enterprise Manager can walk you through taking a backup using a GUI. However, if you're going to be doing this even somewhat frequently, you should learn the BACKUP command, the various options, and also, how to restore from backup and how to recover as much data as possible in case of a failure.


K. Brian Kelley, CISA, MCSE, Security+, MVP - SQL Server
Regular Columnist (Security), SQLServerCentral.com
Author of Introduction to SQL Server: Basic Skills for Any SQL Server User
| Professional Development blog | Technical Blog | LinkedIn | Twitter
Post #422416
Posted Wednesday, November 14, 2007 7:31 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, September 3, 2014 2:52 PM
Points: 1,326, Visits: 1,289
Hi,
Check this link you will have almost all info. about backup and restore.
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlbackuprest.mspx

Regards,
Ahmed
Post #422418
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse