SQL move to another server 1

[surfandsand]

I am new to SQL 6.5 so please forgive me if my question are inexperienced but I am needing to move my exchange data and sql data to another box (exchange 5.5 data move not a problem). I need to know how and what I need to be aware of when moving my databases to the ohter box? Will the SQL enterprise manger take care of everything for this?

Thanks all,
Dom

 

[sguslan]

Backup on the source server then restore the database on the target server.

 

[surfandsand]

I noticed when I back up my sql server data the databases are of course in use so the back up of the databases are skipped when I use backup exec. What should I do to ensure the database and all information that is in use not get skipped so that if I need to restore from backup, I can do that.

 

[toetag]

You best bet is to do a back up manually to file or to tape. since the main DB files are locked open, backupexec will not back them up. Also, you should back up your system DB's as well. If you only transfer your user DB's, all of your logins and security will not be transferred.

are you going from 6.5 to 6.5? or are you upgrading? if you need further instruction, just let me know and I'll send you my email addie and we can go quicker that way.

BTW, side note, you should probably schedule a job to dump the DB's nightly to file or to tape directly (there are pro's and con's to both) then exclude backupexec from trying to back up the DATA directory.

 

[SQLBill]

Don't use Backup Exec as your only backup method. Instead, use SQL Server backup method to backup to the hard drive (.bak files). Then use BE to copy those files to tape.

Then to restore, move the .bak files from tape to hard drive and then use SQL Server to restore the databases.

See the Books OnLine for BACKUP and RESTORE command syntax. Also, take a look through the FAQs for this forum.

-SQLBill