Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wided
Posting Yak Master
218 Posts |
 Posted - 2010-12-09 : 11:02:52
|
| helloi want to restore database from a file, i have this messageUne exeption s'est produite lors de l'exécution d'une instruction ou d'un lot Transact-SQLImpossible d'ouvrie d'unité de sauvegarde c:\fileErreur 5 (Accès refusé) du système d'exploitationResore heade only s'est terminé anormalement ( Microsoft SQL Server, Erreur 3201)What is the problem?Thank you, it's urgent |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-09 : 11:49:45
|
| Looks like you have a directory, and not a file in the restore statement.That, or the service account doesn't have permission to access the file. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-12-09 : 12:38:11
|
| In case helpful details of the creating a suitable Restore Command are here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=54300 |
|
|
|
wided
Posting Yak Master
218 Posts |
Posted - 2010-12-10 : 02:48:11
|
| I can restore from an old file.bakbut not from a new filethe new file is a backup from an other database (sql2008) |
|
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-12-13 : 07:53:26
|
quote:
the new file is a backup from an other database (sql2008)
What happens when you try restoring it to a new database using the new backup file?PBUH |
|
|
|
|
|
|
restore database