Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Restore 2008R2 DB to 2012 DB
Message
De
31/12/2013 10:52:36
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
31/12/2013 09:48:04
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:
01591159
Vues:
51
>System.Data.SqlClient.SqlError: The operating system returned the error '5(Access is denied.)' while attempting 'RestoreContainer::ValidateTargetForCreation' on 'c:\Program Files\Microsoft SQL Server\MSSQL10_50.SQLEXPRESS2008R2\MSSQL\DATA\Lepton.mdf'. (Microsoft.SqlServer.SmoExtended)

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).

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform