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

start by setting the recovery model to simple for this database

and then take a full database backup. This will truncate the log file

Shrink the file to the desired size, if...

if you really need to move logs for the master,model and msdb then use the

alter database modify file command

Tempdb may also be moved but make sure not to touch...

look in sql config manager. Find the instance and on the protocols click TCP. Right click and select preoperties then scroll all the way down. Dynamically assigned port will be...

you'll also get this if you mistype the file and or path too.

Tip: If you do get this message...

winston

just to re iterate

the MOVE is only used when restoring a backup. When moving a data file location via ALTER DATABASE use MODIFY FILE. You can issue the statement while...