as Lynn says, you need to restore the database full backup with NORECOVERYas...

declare @sql nvarchar(max)

set @sql = ''

select @sql = @sql + 'alter database [' + name + '] set offline;

'

from sys.databases where database_id > 4

exec (@sql)

--all system databases occupy id...

what about databases that have open connections what do you want to do about these

have you checked the tape drive

yes simon, the path you provide is relative to the server not your machine.

Hello buddy, fancy seeing you here 🙂

i agree with Markus. Create\use a folder that you have permissions for and use that

can you post the create trace statement you are using

as i mentioned the only thing you may need is login info and database paths\details. If you haven't upgraded the database (which you haven't) you would need to script the...

even so it probably shouldnt be necessary on a daily basis.

although its never failed previously remember the database will change. Extra indexes may have been created, more data now than...

if you have the extra disk resources i personally would prefer a clean install to the cluster

you upgrade you dont perform upgradation there is no such term.

if you did not upgrade the original sql2000 instance the only option you have now is to script the objects...

is it absolutely necessary to rebuild indexes nightly, normally once a week should suffice

visual studio 2003 and visual studio 2005 should be able to live on the same machine