Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Restore 2008R2 DB to 2012 DB
Message
De
31/12/2013 12:02:25
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
31/12/2013 11:16:08
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:
01591179
Vues:
36
>The reference wasn't a lot of specific help but I will check the permissions thingy. But I do agree with his peroration.

That's my blog :).

> I really do not care for MS, but I'm constrained to work on their platforms. Generally MS stuff seems pretty poor to me ( e.g. Win 8 ).
>
>Well, enough of complaining. What I do find interesting after looking carefully at the error message is the reference to the DB being in the 2009R2 "domain". I'm trying to restore a 2008R2 DB Backup ( XXX.bak ) file to a 2012 DB. But SSMS seems to be pointing to the 2008R2 DB mdf??? Don't really understand this.

The original path is probably stored somewhere in the backup, so it defaults to it, but that location belongs to 2008R2 - which may actually have the db open (which would explain the "access denied" in the message).

Just grab the restore script, paste it in an editor window, change the folder and run it. You may get a different error message (knowing that SSMS generated scripts generally need some tweaking), but in the end this should work.

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