Jeffrey Williams (12/29/2008)

---

Changing the recovery model from full to simple will invalidate the backup chain - causing differential backups to fail with the error you are getting.

This could also be...

Matt Miller (12/29/2008)

---

That's the thing though - multi-posting tends to backfire here. Because so many of the regulars use the "active threads" or "recent posts" options to look at...

I'll check tomorrow. Am currently reinstalling SQL.

Please run DBCC updateusage and then run the sp_spaceused again for both the database and the table.

joshcsmith13 (12/29/2008)

---

I can't count the number of times I needed to post a T-SQL question, and couldn't decide if it should go in 2000 or 2005 to get the...

May I ask why a column containing seconds would be confidential information needing encrypting? Who are you trying to protect that column against?

Look up the Encrypt functions that SQL 2005...

Duplicate post. No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic626594-1291-1.aspx

Or zipped and attached, which I personally prefer as...

Jeffrey Williams (12/29/2008)

---

Gail - I have to make sure I remember this link. I see this issue so often now that it would just be easier to link to...

Please post in the correct forum in the future. If you post in the wrong forum, people are...

Alos you need to enable the traceflag globally. If you just do TRACEON(1204) then it's only active for that session, which means you'll never see a deadlock graph as it's...

prasad (12/29/2008)

---

By mistake we replace the actual data with old data by using sql import / export. Unfortunately we dont have the backup also. Is there anyway we can recover...

Please don't cross post. It just wastes peoples time and fragments replies.

No replies to this thread please. Direct replies to: http://www.sqlservercentral.com/Forums/Topic626488-9-1.aspx

Kerry Tyler (12/29/2008)

---

There's just too much general admin/development functions and wisdom that apply across versions that may get lost on someone who only reads, say the 2005 forum, because it's...

The IO warnings are just saying that you're overloading the IO system and the latency is getting very, very high.

Is the second sp_spaceused that you posted from the processcontrol table?...