• Some users have recently had their accounts hijacked. It seems that the now defunct EVGA forums might have compromised your password there and seems many are using the same PW here. We would suggest you UPDATE YOUR PASSWORD and TURN ON 2FA for your account here to further secure it. None of the compromised accounts had 2FA turned on.
    Once you have enabled 2FA, your account will be updated soon to show a badge, letting other members know that you use 2FA to protect your account. This should be beneficial for everyone that uses FSFT.

Copying SQL Database

A

Azhar

Fixing stupid since 1972
Joined
Jan 9, 2001
Messages
18,877
I've done restores in MS SQL 2000 many times in the past, but I've recieved a request to do something different this time around.

My boss wants me to first make a copy of the existing database, then restore the original from yesterday's backup.

That way she would be able to view both databases, the current and the restored.

How do I make a copy of a database?

For example, the original name is LONG_PMDB

I want to make a copy and call it LONG_1

then restore LONG_PMDB to yesterday's backup.
 
I figured it out. It was pretty simple.

1. open SQL Enterprise Manager > Console Root > MS SQL Server > SQL Server Group > (LOCAL) > Databases

2. Rightclick LONG_PMDB > All Tasks > Backup Database and back it up as LONG_PMDB_today

3. Rightclick Databases and select New Database. Name it LONG_1

4. Rightclick LONG_1 > All Task > Restore Database and select Device > Select Device > browse to LONG_PMDB_today, then in the Options tab, select Force Restore.. allow it to restore itself.. will take about 30-45 minutes (55gb database)

5. Again, rightclick LONG_1 > All Task > Restore Database and select Device > Select Device > browse to yesterday's backup, then in the Options tab, select Force Restore.. will again take 30-45 minutes.

That's it. Now you have LONG_PMDB which is the untouched database, and you have LONG_1 which is rolled back to yesterday.
 
You can also use the Copy Database Wizard.
 
Maybe my memory is failing me (after all, SQL 2000 is almost a decade old), but the CDW was in SQL 2000. See KB article 274463, for example. Or these insturctions for migrating from SQL 7 to SQL 2000.

There's no such product as SQL 2007. SQL 2008 hasn't shipped yet.
 
You must log in or register to reply here.
Back
Top