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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 backing up database

Author  Topic 

manared
Starting Member

10 Posts

Posted - 2007-02-20 : 13:54:54
Sorry this is so trivial, but I don't work with SQL Server too much. I just want to back up a table in one of my databases. I'm using SQL Server 2005, the management studio. Can someone walk me through how to back up a table? Thanks!

X002548
Not Just a Number

15586 Posts

Posted - 2007-02-20 : 14:07:45
Back it up to where? A file? Another table?

SELECT * INTO BackupTable FROM myTable999

Or bcp the data out to a file

????



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page
   

- Advertisement -