General information
Category:
Coding, syntax & commands
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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only