Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Backups with Ola Hallengren Scripts

Status
Not open for further replies.

wbodger

Programmer
Apr 23, 2007
769
US
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

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top