May 30, 2006 at 8:22 am
Is there a software package out there that allows me to backup and restore selected tables on MSSQL. I also need to access and perform these taks on remote SQL servers, so I can't be installing software on them. I have recently had a need for such a utility and was hoping someone might know of a good one out there.
Thanks in advance.
May 30, 2006 at 10:29 am
I read that Litespeed from Quest can restore individual objects. Probably others can too. You should use this site's search to find 3rd party backup tools.
Standard procedure with native SQL Server backup/recover is to recover a database from a backup with a new name then use DTS or T-SQL to replace the individual object in the original database.
Greg
Greg
May 31, 2006 at 9:00 am
If all you want are the tables, there's BCP thats part of SQL server. It will give you a CSV file of a tables contents and allow you to put that file into a table in another database. Check BOL for the syntax.
May 31, 2006 at 9:06 am
Yes, all I am interested in is the data as there are times I want to move a table from production to test and don't want to replace the entire database because it is not needed. Thanks for the replies.
May 31, 2006 at 9:19 am
DTS is a lot easier to use than BCP and you can transfer data in one shot instead of BCPing it out to a file then BCPing it in to the other database. Try the Import/Export Wizard.
Greg
Greg
June 1, 2006 at 12:09 pm
From my personal experience with LiteSpeed: you can do backups of individ tables, but somehow restore doesn't work ( but it supposed to work!)
June 6, 2006 at 10:00 am
Unsure what you mean by backups of invalid tables. LiteSpeed allows you to restore individual tables (and all other database objects) from a full backup file. When you say restore doesn't work what do you mean?
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply