wow, as often as that Gail 🙂

bopeavy (6/8/2011)

---

And this Kind of thing is a pain when I have to get a time slot...

Perry Whittle (6/8/2011)

---

Although you have removed the file it cannot be truly dropped until you restart the database, as this is tempdb you must restart the SQL server services (no...

Although you have removed the file it cannot be truly dropped until you restart the database, as this is tempdb you must restart the SQL server services (no reboot required)

:Whistling:

what command did you use to drop the files?

rahulr.sharma (6/2/2011)

---

Hello All,

My motive here is to look for a means to change the Security domain groups that are used for the Clustering services, after the installation is performed.

These...

When moving user databases you dont need to detach them at all.

Issue the alter database modify file statements which will set the new paths. Take each database offline in...

Typically you dump the trace file output into a SQL server table and then query against that

USE Mydb

GO

SELECT * INTO mytracetable

FROM fn_trace_gettable('c:\temp\mytrace.trc', default);

GO

alan.fisher (5/31/2011)

---

Hi I have one SQL Server with about a dozen relatively small databases. I had the data and backup folders all on the same drive (C:\MSSQL10.MSSQLSERVER\MSSQL\Data &...

Hi

both 64k and 256k are optimal stripe sizes for SQL Server. The theory behind the 256K stripe size is that a larger stripe size generally incurs less I\O with 64k...

have you run DBCC checkdb against your system databases

at a wild guess i would say the original disk locations do not exist on the new server.

Does the new server have the same drive letters and paths?

If not you...

again, I'll reiterate, as long as the model database is available

do you mean orphaned database user?

for Tempdb you don't need to do anything. Tempdb is recreated each time SQL Server starts. It does however rely on the model database being available.

If you remove the...