Hi Mike,

You can use RESTORE VERIFYONLY to check for the backup.

See this page fore more info http://technet.microsoft.com/en-us/library/ms188902(SQL.90).aspx

Otherwise you will have to do a restore to be sure.

gr,

Chris

You should be able too copy you DB files to a new installation and do a direct attach. You don't have to detach the db on the expired installation. You...

Hi There,

You can try to set the remote login time to 120 seconds.

EXEC sys.sp_configure N'remote login timeout (s)', N'120'

GO

RECONFIGURE WITH OVERRIDE

GO

In the following line you need to make sure that your index is unique. So you have to check that you are on the right table. Otherwise you can get...