Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Restore 2008R2 DB to 2012 DB
Message
From
31/12/2013 10:54:51
 
 
To
31/12/2013 10:52:36
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2012
Application:
Desktop
Miscellaneous
Thread ID:
01591150
Message ID:
01591160
Views:
47
Default install folder for databases is in the Program Files folder. I always put my databases in a \Data folder. It's solved lots of rights issues and gets data out of Program Files, where it doesn't belong.

>Perhaps What was that error again? will help. Check the account that your SQL is running as, and make sure that that account has the rights... it may be that 2008 has set some attributes or protection there, so any nasty intruders like SQL 2012 wouldn't be able to touch it.
>
>The simpler way, without much fuss about rights, would be to create your restored database in some folder different from this, which wouldn't be touched by hostile software written by competing companies (for instance, Microsoft).
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform