April 13, 2007 at 3:57 am
Hi Guys
I have a backup on one of my servers. I want to restore the backup on a database on a different server without copying the backup to the server that I'm doing the restore on. I know I have to do this in a SQL job.
Can anyone help me with this.
Regards
IC
April 19, 2007 at 2:29 am
"I want to restore the backup on a database on a different server without copying the backup to the server"
When i face this satuation i would take care that second server can access the first one i.e, where .bak file is stored. And i would put that location in restore statement in QA .
im not sure about the job you are talkin about.
ignore this if its not your call.
April 19, 2007 at 2:59 am
Thanks, but my problem was solved a long time ago.
This was the solution to the problem
RESTORE DATABASE [DatabaseName]
FROM DISK = N'\\[ServerName where backup is saved]\MSSQL\Backups\Folder\Backup.bak'
with REPLACE ,
MOVE N'Data File' TO N'I:\MSSQL\data\Data.mdf',
MOVE N'Log File' TO N'K:\MSSQL1\log\log.ldf'
Regards
IC
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply