Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 675
  • Last Modified:

Re-attaching Database - Device Activation Error

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
NEMHCIS
Asked:
NEMHCIS
  • 3
  • 2
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
is G: a local or a mapped drive?
0
 
NEMHCISAuthor Commented:
it is a mapped drive.
0
 
dportasCommented:
That's the problem. Creating or attaching database files on mapped drives is not supported except for certain approved NAS hardware combinations.
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I agree. there are some hacks to make it possible, but you should never do it actually for a production database.
0
 
NEMHCISAuthor Commented:
Damn.  ok.  Thanks for the info.  Any repercussions to 'Shrink Database' command?
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
Except that the files will shrink, and later obviously might need to grow again, no.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now