Information générale
Catégorie:
Codage, syntaxe et commandes
Hi,
A way I've used:
From SSME:
Detach the database in question.
Rename it.
Copy the MDF/LOG files to another location/name
Re-attach the database.
Attach the copy.
HTH,
Viv
>Hi Cetin.
>I have tried that, using Sql Server Management Studio Express, went into Tasks, but Copy is not an option.
>
>Can I backup and maybe then restore to a New dataBase ?
>Regards,
>Gerard
>
>
>
>
>>>I have a Sql server databse up and running and want to make an exact copy, to use for testing.
>>>Is it possible to cpy an exisitng database and have two running side by side?
>>>
>>>Regards,
>>>Gerard
>>
>>Yes you can even cop online. Selct database right click and select 'Copy' from 'Tasks'.
>>Cetin
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement