May 21, 2008 at 11:24 am
I want to Backup all my Database to Share Drive.
"backup database TEST to
@filename = N'\\DEVDR\SpaceZDrive\Test.Bak' "
Where \\DEVDR\SpaceZDrive is Share Drive (Where should I add user id and password in the code)
It was failed. Do I need to pass user ID and Password or any special permission needed.
May 21, 2008 at 11:57 am
I think you can try back up GUI . I guess it should not ask for any User Id or PSSWD.
May 21, 2008 at 11:59 am
Backing up across the network is not a recommended practice. If this is necessary you need to grant access to the share to the user executing the backup. If you are scheduling the backup using SQL server agent then the service account needs access to the share and should be a domain user account.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 21, 2008 at 12:17 pm
You can't do it that way. You can backup to a network drive, but you can't enter creds in the backup command.
The way you're doing it, you have to get the acct the agent/job is running under and give it rights to that drive. Then you'll be good to go.
I actually did a video on this called 'remote backup'...
you can find it here:
http://midnightdba.itbookworm.com/index_files/Page380.html
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
May 21, 2008 at 1:03 pm
Yup your video clips is excellent that's what I was looking for.
Thanks
May 21, 2008 at 1:05 pm
Thanks. Glad I could help.
Watch my free SQL Server Tutorials at:
http://MidnightDBA.com
Blog Author of:
DBA Rant – http://www.MidnightDBA.com/DBARant
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply