June 3, 2003 at 2:27 pm
Why can't I select a different disk to backup to. Only the default disk backup location is available while defining maintance plans or just backup database?
June 3, 2003 at 3:49 pm
space maybe? Only local disks should show up. What does xp_fixeddrives return?
You can also just type the path.
Steve Jones
June 4, 2003 at 5:39 am
What command(s) are you using to backup the database? Maybe there's a typo or error in it.
-SQLBill
June 4, 2003 at 6:10 am
xp_fixeddrives
C4156
D17151
F34648
G68750
H69311
I am trying to backup to g:
I am in EM trying to run a backup.
When I try to add a destination, get errors.
From the errorlog:2003-06-04 07:59:02.91 spid57 BackupDiskFile::CreateMedia: Backup device 'g:\sqlbackupfiles_gitp\master' failed to create. Operating system error = 5(Access is denied.).
June 4, 2003 at 6:52 am
This may be a permissions issue.
Make sure that the SQL Server startup account has "Full Control" permission to the drives you want to backup to.
June 4, 2003 at 9:04 am
The directory was locked.
Created a new directory and it worked.
Thanks for your time
June 14, 2003 at 8:10 pm
Have a look at the sp_addumpdevice stored proc, it will make you life so much better.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply