I have recently come across Ola Hallengren's scripts and have implemented them successfully except... When I went to test restoring the backup from a database, I get this error
I can restore manually each file at a time (From Device, restore full, then differential and then transaction logs), but trying to do a point in time restore results in this error. The only thing that I did was to modify the location so they all (full, diff and trans log) backup to subdirectories under the same parent. Any thoughts on what I should look for or what may be causing this?
Thanks,
Willie
Code:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'kt-sql1.kaasco.com'. (Microsoft.SqlServer.SmoExtended)
For help, click: [URL unfurl="true"]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0038+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476[/URL]
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: Cannot open backup device '{4431E9FC-6836-4284-B48C-9F184635D873}6'. Operating system error 2(The system cannot find the file specified.). (Microsoft.SqlServer.Smo)
For help, click: [URL unfurl="true"]http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0038+)&LinkId=20476[/URL]
------------------------------
BUTTONS:
OK
------------------------------
I can restore manually each file at a time (From Device, restore full, then differential and then transaction logs), but trying to do a point in time restore results in this error. The only thing that I did was to modify the location so they all (full, diff and trans log) backup to subdirectories under the same parent. Any thoughts on what I should look for or what may be causing this?
Thanks,
Willie