September 10, 2008 at 10:53 pm
Following script to restore db and tran log works just fine via QA.
I created a job to restore it automatically using the same script below in the transact sql command box in the create job steps and ran job successfully but it is not restoring the database and tran log.
What could be the possible problem?
Inside the job I have two steps and on each step I have each of the
script below.
Thank you.
RESTORE DATABASE test
FROM DISK = 'D:\Microsoft SQL Server\BACKUP\test_db_200809100300.BAK'
WITH NORECOVERY,
MOVE 'test_Data' TO 'D:\Microsoft SQL Server\Data\test_Data.mdf',
MOVE 'test_Log' TO 'D:\Microsoft SQL Server\LOG\test_log.ldf'
------------------
RESTORE LOG test
FROM DISK = 'D:\Microsoft SQL Server\BACKUP\test_tlog_200809100650.TRN'
WITH RECOVERY,
MOVE 'test_Data' TO 'D:\Microsoft SQL Server\Data\test_Data.mdf',
MOVE 'test_Log' TO 'D:\Microsoft SQL Server\LOG\test_log.ldf'
September 11, 2008 at 1:13 am
Please don't cross post. It just wastes people's time and fragments replies
No replies to this thread please. Direct replies to:
http://www.sqlservercentral.com/Forums/Topic567472-24-1.aspx
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 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply