SQL Server 2000 / SQL Server Management Studio 2008 - How to copy a database?

You'll probably need to backup the DB, then restore it with a the new name (and then get someone with access to do the clean up). This should be OK as long as you make sure that the physical file locations are updated when you choose a new db name.

Up vote 0 down vote favorite share g+ share fb share tw.

I'm connecting to a SQL Server 2000 server with SQL Server Management Studio 2008 and need to make a copy of a database. Right-Click the database and pick Copy Database brings up the nice wizard. When I pick the destination server (the same server as the source server) the wizard happily tells me I need SQL Server 2005 or better and stops.

How can I make a copy of the database? I have no access to the computer other than through the management studio. Upgrading the server is not an option that is available to me.

Sql-server-2000 link|improve this question asked Jan 27 '11 at 18:11Justin8082,6791930 87% accept rate.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.