We use backup exec extensively and have successfully restored sql databases to different servers.

Backup exec has a redirection tab used to tell the system what server to restore to and...

Khickey:

Will that work when using standard security?

I want to thank everyone for the incredible help and support I received on this issue.

I restored the database to the new server using Backup Exec and used the Microsoft...

A microsoft support topic describes this procedure. Since both machines are in the same Domain, it may be feasible. The article number is Q246133

The database we are migrating is version 7 sp1.

Can I use DTS to copy the logins to the new server using that version?

The Problem with Attach detach is that the user accounts are not listed in the security selection on the new server. I have too many users to enter each...

I installed the CD, rebooted the server and discovered the server names were case sensitive in the stored procedures. It worked perfectly! Thanks for all the help.

This is a bit more complicated than drop server, add server. SQL 7 only supports 1 server. When I drop a server, I can't get to query analyzer...

Thanks Steve

We use DNS, so I hope we are home free.

I also like the batch process option. The mget command within FTP seems to get the job done.

I'd like to rename the .TXT files on the FTP server. ...

I am a rookie at VBScript. Could you please show me how to shell out the http://FTP.exe?