December 8, 2011 at 9:28 am
prolly a stupid question but each time i use management studio to backup a db, i get E:\BACKUP as the default location (which does not exist) and the get an error message "cannot access the specified path" when clicking the ellipses to navigate to the correct folder. furthermore, management studio does not see my F: drive which is the drive i want to backup to. (local disk partition). how can i change the default location and get management studio to see the F: drive? (fwiw, it doesn't see the C: drive either). server is a 2 node failover cluster configured disks as:
C: local drive
D: san drive
E: san drive
F: local drive
December 8, 2011 at 9:37 am
December 8, 2011 at 10:29 am
how can i change the default location and get management studio to see the F: drive?
Thought it won't help your see local storage, If you are usintg SQL 2008 - to change the default backup directory, right-click the MSSQL node asnd choose "facets", Under the server facet, change the BackupDirectory. Enter your path.
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
December 9, 2011 at 12:34 am
why is it then that my backup maintenance plan can see the F: (local) drive?
when i access the backup gui in management studio, the information for the last backup (done with the maintenance plan each morning) is visible in the Destination / Back up to: selection.
EDIT: I played around and I can manually enter F:\BACKUP in the backup task in a maintenance plan and backup to that drive. however, using the ellipses to select a drive/folder it cannot see it. so you CAN backup to a local drive. it's just that the SQL GUI cannot see it.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply