August 6, 2009 at 4:24 am
Hi,
I need to take a backup of 7 critical tables daily.
Could somebody suggest me a way to do it through Stored Procedure.
Right now we are doing the same thru SSIS package.Also pls suggest which is the faster method(Stored proc or using SSIS).Any help would be greatly appreciated
August 6, 2009 at 4:38 am
Why backup several tables to file? Are you not taking database backups? If you are, why also backup the tables to file?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 6, 2009 at 5:10 am
Thks for the reply..Actually we are doing a database backup regularly.But this is just as a double precautionary measure.It is easier to put in the data back from the backup table if any data has been corrupted.
Also the tables are not being backed up into a file.They are copied to another set of tables.
One more ques..Is there any easy way to copy back just only one or two tables from the whole backup made?
August 6, 2009 at 5:31 am
Not with the native backup tools. Some 3rd party backup tools do have that feature.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply