8.00.2039 is the regular SP4

Is this a multi processor or multi core box ?

if yes: IMO your should apply the cumulative hotfix I mentioned earlier.

Your extra software will need space, your extra databases will need space, your...

You didn't post the @@version.

This is a sqlserver parallelism issue.

Did you also apply Cumulative HofFix for sp4(build 2187) - SQL2000-KB916287-v8.00.2187 ?

Did you try DavidBs workaround ?

What were the results ?

may sound stupid, but would attaching a USB-drive (low cost high volume (up to 1 TB)) help out to make your local backup ?

Short term, very low cost.

And then...

If you are allowed to use xp_cmdshell you could perform

- your alter

- then put the db offline

- xp_cmdshell 'xcopy "c:\thefile.ldf" "x:\thenewwpath"'

- and alter db online.

With sql2005 you need...

Please check this bugfix :

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

This hotfix states "This problem was first corrected in Microsoft SQL Server 2000 Service Pack 3"

Which is your sqlsever @@version ?

(maybe it's time to implement...

Chandu (9/4/2008)

---

I have to install multiple instances of SQL 2005 using unattended install scripts. Is it only the database engine that should be installed multiple times OR even client connectivity...

double check your provided ddl data used during install!

I've found this to be interesting :

http://www.sql-server-performance.com/da_email_functionality.asp

Can your service account reach the mail server ?

like from prod to dev ?

make the .bak file available to your sqlagent service account on your dev-server and have a job restore the db.

Alter database mydevdb set single_user with...

- please post the sqlserver version info.

Select Serverproperty( 'ProductVersion' ) as ProductVersion

- did you check the fixlist for the available cumulative hotfixes (9) for this kind of...

There is a separate KB you need to read which explains the procedure to follow for system databases !!

Check "Restoring the master Database" in BOL

http://technet.microsoft.com/en-us/library/aa176749(sql.80).aspx

Rem,

I would leave the affinity default.

Gail,

Thanks for the bol ref.

Yes you can.

We try to avoid it (just in case...)

Books online has the cluster install procedure.

-Keep in mind to prepare your Windows groups to host the instances service accounts

- Keep...

With sql7 and sql2000 you're better off putting your user objects NOT in the primary filegroup, but is your own added filegroup(s).

Reasons ? Think IO parallisme.

- you can place an...