Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Restoring a large database to a mapped drive

Posted on 2010-08-30
12
Medium Priority
?
405 Views
Last Modified: 2012-05-10
Hello,

I need a restore a database of 270GB. The .BAK is about 1GB (there is still alot of open space in the databse). I have mapped the network drive. I have started the SQL server with a account that does have read and write access on the LAN.

I changed the destination of the restored files (DB + LOG) to the Y drive (mapped LAN drive) in SQL management studio.

I get the error "The file "Y:\temp\abraham\db" db is on a network path that is not  supported for database  files.

Can you help me to fix this ?

Abraham
0
Comment
Question by:AbrahamVlok
[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
  • 7
  • 3
12 Comments
 
LVL 30

Accepted Solution

by:
Rich Weissler earned 2000 total points
ID: 33557545
http://support.microsoft.com/kb/304261
Very strongly not recommended.
_IF_ you insist on pursuing that avenue, "Trace flag 1807 bypasses the check and allows you to configure SQL Server with network-based database files."
0
 

Author Comment

by:AbrahamVlok
ID: 33557592
Hi Razmus,

I do not care about this as I am restoring a database to check settings - it is not running anyhting.

How do I set the trace flag ?

0
 
LVL 30

Assisted Solution

by:Rich Weissler
Rich Weissler earned 2000 total points
ID: 33557689
In this case, you'll probably want to stop the sql service, and add the parameter -T1807 to the service executable.

http://technet.microsoft.com/en-us/library/ms187329.aspx
In theory, you should also be able to run it as "DBCC TRACEON (1807, -1);" from a query... but I personally don't run trace flags that way.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:AbrahamVlok
ID: 33557751
I managed to change the tracflag - but still I get the same error.

This traceflag is related to "5110 "File 'file_name' is on a network device not supported for database files."

This is not my error.5110 is related to device problem. I have a path problem.
0
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 33557838
Thats exactly the message that Trace flag 1807 is suppose to disable.  Confirm "DBCC TRACESTATUS (1807, -1);" ?
0
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 33557864
Hmm... Also confirm that this instance of SQL is not a cluster?
0
 

Author Comment

by:AbrahamVlok
ID: 33574808
The investigation took too much time, I had to make alternative plans. I found an external USB disk and performed the restore to that.
0
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 33575819
I'm sorry the investigation was taking so much time.  

Were you able to confirm that the SQL Server wasn't part of a cluster, and confirm that the DBCC TRACESTATUS (1807,-1) was reporting positively?
0
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 33577594
The poster may have taken excessive time on the issue, but the question asked was answered.  Additional troubleshooting information which might have assisted in the eventual successful resolution was not provided.  (Or, if the server is part of a cluster, which has not been answered, would have concluded that the solution he desired is no possible.)
0
 
LVL 30

Expert Comment

by:Rich Weissler
ID: 33582544
My biased recommendation is #3, with the answer being http:#33557545
Comments below that were attempts to assist the user in implementing the answer.

The answer gives the correct answer on how to accomplish the task requested, and the link provided the documentation from Microsoft with further information about the reason the option is not recommended, risks associated, and circumstances under which the one solution may still not work as desired.  The final solution implemented, namely use of supplemental storage directly attached to the database server, is also actually in compliance with the suggestion in the answer -- that the one solution to the question as posed is very strongly not recommended.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

Introduction This article will provide a solution for an error that might occur installing a new SQL 2005 64-bit cluster. This article will assume that you are fully prepared to complete the installation and describes the error as it occurred durin…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

609 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