Compresses, encrypts, secures and monitors SQL Server backups.
Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey
I am getting error when my restore jobs fails. my restore database name is same as backup database name.
I am restoring from shared location. but when i copy that backup file to local disk. restore works, but fails with that error when i restore from shared location.
Any help is greatly appreciated.
- Posts: 4
- Joined: Fri May 04, 2012 6:59 pm
When restoring from a network share, you need to ensure that the SQL Backup Agent service startup account has rights to access that network share.
You can check if that account has read/write/delete rights by running the following:
- Code: Select all
EXEC master..sqbutility 999, 'RWE', '<your network share path>
What is the returned result?
SQL Backup Consultant Developer
Associate, Yohz Software
- SQL Backup goodies under the hood, updated for version 7
- Posts: 2233
- Joined: Sun Apr 24, 2005 12:34 pm
Return to SQL Backup 6
Who is online
Users browsing this forum: No registered users and 0 guests