Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

In SQL Server Management Studio for SQL Server 2008, I do the following:

  1. In the Object Explorer windows, right click on the database
  2. Choose Tasks -> Back Up...
  3. The Back Up Database windows appears. I choose 'Disk' under Destination
  4. I choose 'Add...' under destination
  5. The Select Backup Destination window appears. I choose '...'
  6. The Locate Database Files window appears.

Now I want to save it to a network drive, but there are only three drives to choose from (C,G,H). But in any other place in windows there are C, and the network drives K, Q and Z. Why can't I save it on a network drive? And what is drive G and H? I'm fine with saving it on G or H, but where is it and how much space is left on these drives?

share|improve this question
add comment

migrated from stackoverflow.com Oct 1 '12 at 19:41

This question came from our site for professional and enthusiast programmers.

1 Answer

Are you using SMSS on the actual SQL server?

Or are you using SMSS on a local machine then connecting to SQL server over the network?

If you are connecting to a remote SQL Server over the network that would explain the differences in the drives you're seeing.

share|improve this answer
    
The drives available in SSMS for the backup destination are the drive letters visible to the specific service SQL Server is running under. A default installation will typically only show the drive letters that are physical drives attached to the machine the SQL Server service is installed on. –  Max Vernon Oct 1 '12 at 20:35
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.