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...

James Horsley (9/3/2008)

---

I don't really agree - surely...

Rem,

Can you post sqlserver version info (sp/cu) ?

Gail,

Do you have a kb ref for the min = max memory config problem ?

Indeed, this guideline to enhance IO still goes for sql2005 and 2008.

However, if you're going for partitioned objects, you should keep in mind there is a huge advantage in keeping...

We just created a "group mailbox" (=classic mailbox) and granted every dba read of the mails. This way every dba can see if a mail has been handled or not.

sanjeev_krs2004 (9/2/2008)

---

Thanks a lot 🙂

I got it; could you please tell me how to use for loop if I need to pick up one of the different lookup (drop-down) values.

for...