How do I make a copy of a SQL7 database on the same server?

[fos]

How do I make a copy of a SQL7 database on the same server? I'v tried Backup/Restore-to-new-DB-name and that don't work. I need to script this so that the backup is current once a week.

Thanks,

FOS...

 

[foxdev]

Go to the source database and choose the Export Wizard; walk through the steps, choosing the target database as the destination.

Robert Bradley

http://www.foxdev.com/

 

[swilliams]

You do not need to script backing up the database. If you manually backup the database, there is an option to schedule the backup (make sure you select things like "Overwrite existing media", ...)

Simon

 

[VANMAN]

Hi
When I tried to do this I keep getting an error on copying the user login. eg XXX\eeeee this is an old style of login with a back slash in it and it exports up to this point and fails.
It is as simple as removing them??

VANMAN