Try this:

Step 1:

alter database dbname

set single_user

with rollback immediate

Step 2: (Immediately after Step 1)

Restore database dbname from device = '<filepath>'

Your databae will be in multi_user mode after the restore. If not...

Expand the log file size and set autogrow on; if your datatabase is production. If not you can put database in simple recovery mode.

If you have configured database mail; check your mail profile by sending test mail.

http://msdn.microsoft.com/en-us/library/ms190307.aspx

HTH

In addition to above, check if the SORT_IN_TEMPDB option is set to ON while rebuilding indexes than SQL Server will use tempdb.

Check following article for further detail.

http://msdn.microsoft.com/en-us/library/ms188281.aspx

Thanks Jeff, good question.

Yes, you can configure Database Mail or SQL Mail. I prefer Database mail.

Sonds good.

You can also disable any constraints, business rues, checks etc before BCP and once BCP is done enable it. Also if possible you can use TABLOCK hint.

HTH

You can use SSIS to transfer logins.

You need to check with your mobile service provider and ask for mail address for your mobile number. e.g. in some of the case mobilenumber@serviceprovider.com where you need to put...

As explained above, if you do not have space issue go with LS. This will help you to minimize the donwtime too.

Both collation are same. There is no difference in collation eventhough SQL Server version changes. I prefer to install the same collation of SQL SERVER 2008 as SQL Server 2000.

Cheers!

You are correct LS is ont timezone aware and it based on LSN.

What you can do here is you need to set up LS manually or write step of restore...

Option 1:[/u] You can either perform rebuild/defrag indexes on existing box before do the full backup

or

Option 2: rebuild/defrag indexes on the new box after the restore.

Now, if your existing...

Enable traceflag 3605 which will help you to capture the information in sql log. Refer following link for further detail:

http://support.microsoft.com/kb/832524

HTH

Nice Question!!!