Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Restore 2008R2 DB to 2012 DB
Message
De
31/12/2013 10:54:51
 
 
À
31/12/2013 10:52:36
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2012
Application:
Desktop
Divers
Thread ID:
01591150
Message ID:
01591160
Vues:
42
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform