Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error when attaching database
Message
 
 
À
29/04/2004 16:58:56
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Copies de sauvegarde
Divers
Thread ID:
00899501
Message ID:
00899518
Vues:
22
You are right. But it didn't (or at least I didn't see it there). But now, after rebooting the PC I see the database there. Either it was there and I missed it, which is possible, or I had to reboot.

In any event, I am glad it is there.

Thank you very much for your help.


>If you restored the backup using SQL Server's RESTORE command, the database was automatically created and attached to the server.
>
>-Mike
>
>>I restored a database to my drive, there were no errors. I see two files on the drive, MY_DATA.mdf and MY_LOG.ldf. Now, I think, I need to attach this database to my Databases (since I never had it before).
>>
>>But when I select to Attach and select the file MY_DATA.mdf, I get the following error:
>>
>>
>>Error 5123: Create File encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the physical file E:\MyFolder\MY_DATA.mdf'.
>>
>>
>>Any suggestions what I might be doing wrong or why I am getting this error?
>>
>>Thank you
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform