Backing up single tables in SQL Server Question. 1

[Apollo21]

Ok, I know the answer to this must be simple, but I can not find it in the documentation. I am running SQL Server 2000 Standard Edition on a Windows 2003 Server. I have restored a backup from another server and all is well. There happened to be a table that did not make it in the initial backup, so now what I want to know is there a way to just backup one or two tables within a database and restore them to the destination server where they currently do not reside?

Thank you very much for answering.

Apollo21

 

[ptheriault]

No there is not. You should use DTS to import the tables that are missing.

Right click on the database on the source server and select all tasks -> import. The wizard will walk you through the import.

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[mrdenny]

If the table existed in the database when the backup was taken then it is included in the backup. There is no way to exclude files from a database backup.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Apollo21]

Denny, Just to clarify, the table was there but the contents were supposed to have populated the table did not come along. Someone forgot to populate the table. Thank both of you for your answers.

Apollo21