Solved

Restoring a large database to a mapped drive

Posted on 2010-08-30
12
354 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
  • 7
  • 3
12 Comments
 
LVL 29

Accepted Solution

by:
Rich Weissler earned 500 total points
Comment Utility
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
Comment Utility
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 29

Assisted Solution

by:Rich Weissler
Rich Weissler earned 500 total points
Comment Utility
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
 

Author Comment

by:AbrahamVlok
Comment Utility
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 29

Expert Comment

by:Rich Weissler
Comment Utility
Thats exactly the message that Trace flag 1807 is suppose to disable.  Confirm "DBCC TRACESTATUS (1807, -1);" ?
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 29

Expert Comment

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

Author Comment

by:AbrahamVlok
Comment Utility
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 29

Expert Comment

by:Rich Weissler
Comment Utility
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 29

Expert Comment

by:Rich Weissler
Comment Utility
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 29

Expert Comment

by:Rich Weissler
Comment Utility
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

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

728 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now