Click here to Skip to main content
15,867,308 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
before i use SQL Server2005..i'm new to SQL server2000.i m n need to take back up in SQL server2000.
Posted
Comments
Mehdi Gholam 18-Nov-11 8:56am    
Taking backups are a sensible thing to do in any case, but are not needed for an upgrade.
Amir Mahfoozi 19-Nov-11 0:54am    
I have updated my solution.

If you want to take a backup from existing database here is a simple TSQL backup command :

SQL
BACKUP DATABASE [NorthWind] TO  
	DISK = N'c:\backup.dat' 
	WITH NOFORMAT, NOINIT,  NAME = N'Northwind Backup'


See the syntax here :
http://msdn.microsoft.com/en-us/library/ms186865.aspx[^]

To restore back the data use this command :

SQL
RESTORE DATABASE [Northwind] FROM  DISK = N'c:\backup.dat' WITH  FILE = 1,  NOUNLOAD,  REPLACE,  STATS = 10


Hope it helps.
 
Share this answer
 
v2
Comments
Mayjo Antony 19-Nov-11 3:48am    
yes.. itz really helpfull for me also.
RaisKazi 20-Nov-11 11:06am    
Reminded me days of "SQL Server 2000". :) 5ed.
Amir Mahfoozi 21-Nov-11 0:08am    
Thank you Rais. And it was developed so reliable that still uses the same commands.
Thanks a lot..it works successfully.how to restore it?
 
Share this answer
 
Comments
RaisKazi 20-Nov-11 11:04am    
Please post your comment in the same Solution section to which you want to address by using button -"Have a Question or Comment?". This will also send notification email to corresponding person.
Muthu Vinoth Kumar 21-Nov-11 1:22am    
thanks
if you want to Restore a Database Backup (SQL Server Management Studio).

try this,
http://msdn.microsoft.com/en-us/library/ms177429.aspx[^]
http://msdn.microsoft.com/en-us/library/ms188223.aspx[^]
 
Share this answer
 
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900