No you cannot restore a single table, it has to be the whole database.

Well in that case, if you have never done a transaction log backup, the actual log is the chain.

So backup the log, restore the 6 day prior db to a...

Do you backup the transaction log or not? What recovery model is the database?

Looks like you need change data capture then, which is a SQL Enterprise only feature, either that or create custom triggers on the tables in question to log to an...

Do you not know of anyone who has access to the SQL server as a db_owner of the database in question or db_backupoperator in the database in question, or a...

What specifics do you want to audit?

raheelr 63130 (8/7/2012)

---

can i backup the transaction log and use the full backup (6 days) prior to the deletion and restore the database with stopat (a time just before the...

If you have a backup you can recover. But 6 days prior to the delete, you will only get the data as it was 6 days prior, you wont...

Existing server on a VLAN which is not behind the firewall?

Yes you will need to open the port SQL runs on and if its a dynamic port, set it to...

Query sys.dm_db_persisted_sku_features in each database, it will tell you what Enterprise features are being used.

Use the dd-MMM-yyyy format string instead.

Check this link out for other format strings

http://msdn.microsoft.com/en-us/library/8kb3ddd4%28VS.71%29.aspx

Two individual primary keys - No

A primary key which spans multiple columns - Yes

What is it your trying to acheive?

Could get cleaver and put in a UNIQUE NONCLUSTERED index on...

Look back through the topic, I gave...

didi77 (8/7/2012)

---

Today, I retest the same thing of yesterday always on my test server...

i'm totaly lost

what was working yesterday wont today...

with this error message at the restore of the logshipping...

you have the spid from dbcc opentran, now look in sys.dm_exec_sessions for that spid