how to take back up from server side to local sql server 2005

[nityaprashant]

Hello guys..

again i need ur help..

how to take back up from server database to local database..

for e.g. i have one database named jewellary on serevr side..& i need it's back up on local sql server 2005..

could u plz help me how to do that?

thanks..

[Shashi Sadasivan]

Try the copy datatabase.

You can define the source and teh destination servers and an create a database there.

However a backup is never to another server, as it defies the ideology of a backup (a backup is supposed to be immutable)