May 21, 2008 at 8:32 am
I want to Backup all my Database to Share Drive.
@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 1:21 pm
Where and how are you running this? If through SQL Server Agent, the account running the agent should have rights to the data share. You won't have to pass any values.
-- You can't be late until you show up.
May 21, 2008 at 5:59 pm
Do you have error message for the backup failure? Any related info from errorlog?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply