Send me the audit file and I'll see what I can do.

What do you mean with the log entries are available from the next day onward? Do you truncate the log daily or something? If that's the case I...

Doesn't matter that you don't have the log backups because you can take 1 NOW.

Ask the user when the dataloss occured.

Then here's where it goes to trial and...

Is the DB in full recovery?

Do you have a full backup prior to the data loss?

Assuming you didn't delete the longs or truncate it you should be able to recover.

She just did.

You shouldn't just add index without...

What's wrong with re-hiring Larry? He was doing an...

I found this on google, does it help?

http://technet.microsoft.com/en-us/library/dd277388.aspx

Lavanyasri (7/29/2011)

---

HI ,

You have any idea why its happened ?? This is new Server frershely installed SQl server .I moved all the databases including system databases from other...

My train of thoughts is that I can't leave a copy of the DB to restore immediately so I have to wait up to 24 hours before actually attempting the...

- Win. (7/29/2011)

---

I am sorry, I should have been more clearer...

But we need this to be implemented in 2000 & 2005 servers as well.

Not C2 auditing. Simply enable server properties...

You need to reinstall your client tools at least.

Why not give my link...

Ping me back tomorrow morning if I forget. I have something even better than that.

What's that?

--Add 1 month, add 1 - day of month (puts you on the first of the month) ... to today's date without the time part

SELECT DATEADD(M, 1, DATEADD(D, 1 -...

PS, it's SSMS (management studio)