Are there any way to restore db from one server to another, if I know other server IP address? Can I do it by sql-script or some wizard? I use MS Sql Server Managment Studio 2008
+1
A:
As far as I know, you must do this in a two step process: create a backup file from the source database server, use the backup file to restore onto the target server. You can script the backup and restore presuming that one server can talk to the other, the destination server could (assuming the appropriate permissions), fire off a backup to an accessible location and then restore from that file.
Thomas
2010-06-22 15:12:49
How do I restore backup on other server by script or wizard? I don't want to copy backup file from one server to another manualy because of its size.
Kate
2010-06-23 07:43:28
@Kate - You would need to write a script to do it. If you do not want to copy the backup file, you would need to put it in a mutually accessible folder. The source server would drop the backup file into that folder and the destination server would restore from that folder.
Thomas
2010-06-23 15:25:41
Thomas: " The source server would drop the backup file into that folder and the destination server would restore from that folder" - And how do I get access to that folder?
Kate
2010-06-23 15:39:23
@Kate - It has to be a folder that is created that both servers can access. The source server must have write access to drop the backup file there and the destination server must have read access to read the backup from there to do the restore.
Thomas
2010-06-23 15:55:57
+1
A:
Hi,
TSQL script as
USE DATABASE -- TO TAKE BACKUP
GO BACKUP DATABASE XXX -- XXX IS DATABASE BACKUP NAME
TO DISK = '\\YYYY\XXX.BAK' -- YYYY IS THE SHARED FOLDER TO YOUR BACKUP AND RESTORE SERVERS NEEDS TO ACCESS PERMISSIONS ON THE FOLDER AS SHARED TO AVAILABLE FOR BOTH SERVERS.
GO
USE MASTER
RESTORE DATABASE XXX
FROM DISK = '\\YYYY\XXX.BAK'
GO
thanks prav
praveen
2010-06-24 22:38:20