All you need is the BACKUP and RESTORE commands, plenty of information in BOL or the internet

BACKUP LOG dbname TO DISK = 'some path'

RESTORE DATABASE dbname FROM DISK = 'some...

Ah, you posted in the 2008 forum, so you got a 2008 answer.

I'm not aware of a 2005 equivilant, but you might find it on google or another search engine...

You are putting the database name inside the ''

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...