Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 357
  • Last Modified:

SQL 2008 Backup

Can we backup databases for Window 2008R2 on a network drive as I can't see it under Management Studio Management although it can be seen under Window Computer Management ?

Tks
0
AXISHK
Asked:
AXISHK
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
network drives as being mapped drives are only visible to a session, hence by default, you cannot back to a network drive.

you could use the steps described here to map a drive in the sql server session, but its not really recommended and requires the startup procedure to redo the mapping each time the sql server starts:
http://blogs.msdn.com/b/sqlserverfaq/archive/2009/02/27/how-to-backup-sql-server-databases-to-a-mapped-drive.aspx


other than that, please refer to the official documentation:
http://msdn.microsoft.com/en-us/library/ms179313.aspx
0
 
Jerry_JusticeCommented:
Guy is correct about mapped drives.

However, you can always back up using a UNC if that resource is available to the account running SQl Server.

In other words, instead of "P:\SQLBackups\MyBackup.bak", use the UNC which might be "\\SERVER03\Resources\SQLBackups\MyBackup.bak".
0
 
Jerry_JusticeCommented:
Did this solve your problem?
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now