Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 How to backup the data in SQL Server?

Author  Topic 

jsc0624
Starting Member

13 Posts

Posted - 2007-04-26 : 08:10:35
Currently my SQL Database has more than 10,000 records on it. What must I do to backup my data in SQL Server, so that I may not accidentally lose all the data I have during my web development?

===============
JSC0624
===============

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-04-26 : 08:13:16
use the BACKUP DATABASE

see
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=37825
http://msdn2.microsoft.com/en-us/library/ms186865.aspx
http://msdn2.microsoft.com/en-us/library/ms175477.aspx


KH

Go to Top of Page
   

- Advertisement -