Solved

SQL 2008 Backup

Posted on 2014-07-22
3
340 Views
Last Modified: 2014-08-05
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
Comment
Question by:AXISHK
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 300 total points
ID: 40211146
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
 
LVL 3

Assisted Solution

by:Jerry_Justice
Jerry_Justice earned 200 total points
ID: 40211302
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
 
LVL 3

Expert Comment

by:Jerry_Justice
ID: 40217461
Did this solve your problem?
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question