Using that does not do what you are expecting it to do - it is a holdover from when the devices were tape.

Stop using a device - use a folder,...

I would recommend changing the recovery model to simple since it is only a dev server. I would also recommend that you start backing up the database daily -...

Yes, as long as you have the transaction log entries available you can use a tool like that to recover. Glad you were able to get it back where...

Yes, there are restrictions on database names - and there are quite a few special characters that will cause problems.

You probably could have gotten around that particular error by quoting...

Unfortunately, your only option is to go back to the old backup and restore. You can restore to a separate database and then perform a comparison on just that...

Dates are not stored as formatted strings in SQL Server. The client you are using will display the datetime value according to how the client is set up and...

rrajkumar17 (12/24/2009)

---

I do agree 4 MB is too less for a log file. But its been working fine without issues for years. Our DBAs changed the size of one of...

Michael Valentine Jones (12/23/2009)

---

I often schedule a job to run sp_updatestats on each non-system database on a daily basis.

This procedure was greatly improved with SQL 2005 to only do updates...

Lynn Pettis (12/21/2009)

---

CirquedeSQLeil (12/21/2009)

---

Lynn Pettis (12/21/2009)

---

Jason is right, you don't have a WHERE clause to join the two tables in the second FROM clause (the UPDATE statements FROM clause). ...

Well - you're probably missing the ability to access the linked image. The code is...

First, I don't believe SQL Server actually stores login attempts. You can find that information in the event log and/or SQL Server log.

Second, the only way the owner of...

Lynn Pettis (12/21/2009)

---

SQL Iron Chef (12/21/2009)

---

Actually I didn't! I was just trying to...

If you want SQL Server to be able to access more than 2GB of memory, then yes - you need to...

I am not sure, but I don't think the EMPTYFILE option actually works with log files. You need to issue checkpoints until the VLF is located in the primary...

If you rebuild your indexes, you don't need to re-organize them. Also, there is no need to update statistics on index statistics after a rebuild. However, if you...