Hi, I am planning to set-up my production ennvironment. I am wanting to know if its best to have the primary node as a physical server and the secondary node...

I think sql 2012 provides redundancy at DB level as well?

Hi...please vet my script, if i am doing the right thing here:

RESTORE DATABASE test

FROM DISK='D:\BackupFiles\TestDatabaseFullBackup.bak'

WITH NORECOVERY;

RESTORE LOG test

FROM DISK='D:\BackupFiles\TestDatabaseTransactionLog.trn'

...

thanks. if i use the GUI to backup the transaction log, on the options tab i see:

-truncate the transaction log

-backup the tail of the log and leave the database in...

ok thanks. any script which can help me achieve this please?

can i just restore one table i want using this option you have advised? do you have any sample scripts which could be of assistance.

thank you so much. so if i undertsand it correctly i have to do this now:

1. backup the transaction log from the production database (where the data has been deleted)

2....

my recovery model is full and i dont backup the transaction log. this database is just 3 months old and ever since no transaction log backup has been done, only...

i have another backup which is 8 days after the deletion. will this work with transaction log?

I dont purge or truncate my transaction log so i believe the full log is thier. the size of the db is apprx 19gb and the log is around 23gb

changes to DB records on all the tables in a number of databases, the user making the changes and the date and time

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 deletion)? will...

can i create a database as audit and log all changes to this audit database? if so how can i achieve this?

actually i just came to know that have a backup file which is 6 days prior to the day the record was deleted.