Solved

Re-attaching Database - Device Activation Error

Posted on 2008-06-25
8
649 Views
Last Modified: 2011-10-19
I need to move some SQL databases to a new drive because I am running out of room on the existing drive.  I found the how to do it via this link: http://support.microsoft.com/kb/224071/EN-US/

I got to the point of re-attaching the database.  The path of the new location of the databases is G:\Data.

However, when I try to run the script - I get a device activation error.  Please see my screenshot
deviceactivationerror.gif
0
Comment
Question by:NEMHCIS
  • 3
  • 2
8 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 21866465
is G: a local or a mapped drive?
0
 

Author Comment

by:NEMHCIS
ID: 21866536
it is a mapped drive.
0
 
LVL 22

Accepted Solution

by:
dportas earned 250 total points
ID: 21866650
That's the problem. Creating or attaching database files on mapped drives is not supported except for certain approved NAS hardware combinations.
0
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 142

Assisted Solution

by:Guy Hengel [angelIII / a3]
Guy Hengel [angelIII / a3] earned 250 total points
ID: 21866682
I agree. there are some hacks to make it possible, but you should never do it actually for a production database.
0
 

Author Comment

by:NEMHCIS
ID: 21867724
Damn.  ok.  Thanks for the info.  Any repercussions to 'Shrink Database' command?
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 21868377
Except that the files will shrink, and later obviously might need to grow again, no.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

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…
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

930 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

9 Experts available now in Live!

Get 1:1 Help Now