Isn't it strange how problems like this are always the fault of the database and not the developer? :crazy:

Anyway, I'd be inclined to set up a trace on the server...

While it's possibly right that high disk queue length is not a problem on the SAN, especially if your users aren't reporting any issues, I'd still say it's worth checking...

Saying that a person with a salary is a fixed cost to the company doesn't always work--for instance, I used to work for a programming company, and all the programming...

You say you have both a BAK and an MDF, but you've only talked about re-attaching the MDF file. I assume you've tried to restore the BAK and that failed?

Baskar B.V (5/27/2010)

---

The trace file got created successfully but it showing only "0" bytes. I am assuming the process has access since it has created the trace file in the...

I play computer games, mainly. Means I'm staring at a monitor all day at work and all day at home as well, but I think the two actions are otherwise...

Lowell (5/24/2010)

thos operating systems changed, compared to XP; they no longer make your login an sql administrator when you install 2005/2008, you have to do it as a seperate...

Another good reason for not using the One True Lookup Table is the lack of flexibility. Your requirements right now mean that all those different lookup types have the same...

The main issue with using Postgres or MySql when you're already a SQL Server shop is that the dialects of SQL are slightly different, so you'd potentially have to rewrite...

And is "master" the default database for this user according to the properties in Security->Logins?

Andy Hogg (7/24/2009)

---

True you can use a UNC path in a scripted backup \ restore as per the example given, but you can also use UNC paths within Enterprise Manager...

No. SQL Express will only make use of one CPU no matter how many are installed in the machine, so it's not like you're gaining anything by running it on...

Gianluca Sartori (5/3/2010)

I was confused too, Grant. I was sure MSDE 2000 had a 5 concurrent connections limit, but, after searching a bit, I found out that Express Editions (starting...

Has it? The Microsoft download site for SQL Express still...

I misread the question too...just re-read it and realised it meant the last differential before the corrupt backup, not the last one taken. D'oh!