October 21, 2010 at 4:48 am
Hi,
I want to take backup data for every three months once and i want to implement copy that data to another server. How can i do this i am new to this concept.
Thanks & Regards,
Jeevan.
October 21, 2010 at 4:56 am
Jeevan
You can write scripts to do this in T-SQL, but file manipulation isn't what T-SQL is designed for, so you're probably best creating a SSIS package to back up the databases and copy the files to another location.
John
October 21, 2010 at 5:03 am
Hi john,
Thanks for your spontaneous response. can you please give me any guide lines how to do this.
Jeevan.
October 21, 2010 at 5:08 am
I seriously hope you're backing up more often than that.
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
October 21, 2010 at 5:27 am
GilaMonster (10/21/2010)
I seriously hope you're backing up more often than that.
Perhaps the OP means that in addition to the "best practice" backup strategy they are following, they would like to copy and restore the database to another server every 3 months ?
October 21, 2010 at 5:35 am
yjeevanrao.net (10/21/2010)
Hi john,Thanks for your spontaneous response. can you please give me any guide lines how to do this.
Jeevan.
Jeevan
Search on the internet for introductory tutorials for SSIS, then work through one of them until you've written your first package. By that time, you should be confident enough to create a package to do the backup and copy.
John
October 21, 2010 at 5:50 am
A simpler, but less robust method would be to:
1) Take a backup to MyDatabase.BAK
2) Create a BAT file to copy MyDatabase.BAK to the target server
3) Run a T-SQL script to restore the backup.
2 & 3 could be run from the target server as steps of a job.
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply