Thanks for the tip Gail!

Grant Fritchey (8/17/2011)

---

Perry Whittle (8/17/2011)

---

not available in SQL Server 2005, you...

Try to start SQL with this

sqlservr.exe -d"C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master.mdf"

-e"C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log\ERRORLOG"

–l"C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\mastlog.ldf" -m -c -syoursqlinstance

Following Perry's advice should solve your problem, the question is do you know how to set the location for the files?

So did you solve your problem?

prem.budhu (8/12/2011)

---

Hello,

some of my users are having some performance issues with an application that uses sqlserver 2005 and I am running the profiler to get some stats....

prem.budhu (8/15/2011)

---

Thanks,

here is what I see after running the command

select name,filename,size/128"Actual Size",maxsize/128"Maxsize",fileproperty(name,'spaceused')/128"spaceUsed" from sysfiles

Database -- actual size =78981, max size =0 space used = 68741

DB_Log -- Actual size = 170806,...

Did you...

How much space you have on your C drive?

Roy Ernest (8/12/2011)

---

This is the query I usually run to find the wait types. I got this query from Glenn. It gives me a good break down of the wait...

Are you able to see something on the SQL Server Errorlog or on the Server eventlog?

It is possible, you can create file groups and backup the file groups, you can find a lot of information on the internet regarding this, check this link. In case...

Nice link Ninja, thank you for sharing!;-)

You should run the following script and post the results select name, log_reuse_wait, log_reuse_wait_desc from sys.databases where [name] = 'yourdb'

If you have log shipping enable for that database, the transaction log backups must have been already taken. Check this.