>Hi
>
>
>I've installed SQL2005 on my local machine and I want to take a copy of a database from the live server and install it on my local SQL server.
>
>Whats the best way of doing this.
>
>Thanks
>
>
>Nick Mason

Make a backup of the database and you will be able to restore it.

Alternatively, you can detach database from the server, copy the files, attach back to the server and also attach to your local server.

This will work as long as the server has SQL 2005 also (no higher version).