Post reply

copy job

  • October 13, 2009 at 3:43 pm

    #136455

    I have 2 databses on SQL server1.I want make a copy of these databases every night to other server2.

    first step would be delete these tables on server2 evry night

    the copy the tables from server1 to server2.

    How can i wriite a job to do this.

    Thank you

    --sh

  • October 13, 2009 at 3:52 pm

    #1065432

    For this, I would do a backup and a restore to get a full copy of each database on the second server.

  • October 15, 2009 at 10:17 am

    #1066379

    Can you please detail the steps how i can do this.

    mysource is sqlserver7 and destination is sql2005.

    I tried using the Transfer databse task but it has version compatibilty issue.

    Thanks,

    sh

  • October 16, 2009 at 11:15 am

    #1067067

    You can restore a SQL 7 backup to a SQL 2005 server

    1 - On the SQL 7 box create a SQL Agent job to backup the database to a location common to both servers. (Note: The windows account that runs the SQL Server service must have access to the network share. Local System account will not work.)

    2 - On the SQL 2005 box create a SQL Agent job to restore the database from the file previously backed up.

    You should also run DBCC UpdateUsage ('database_name' ) to correct some internal statistics that do not update when this type of restore is done. You can do this as an additional job step in # 2 above.

    If the proper SQL syntax for backup / restore is a problem for you, you can use SQL 2005 Management Studio to script the commands via the GUI.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply