[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

SQL 2008 Backup

Posted on 2014-07-22
3
Medium Priority
?
359 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
  • 2
3 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 1200 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 800 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

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

612 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