Hi All,
This is a request from client.
They need full database backup. but they onlu want to restore full backup once, and then apply all the changes later. During ant time, they can query the database.
What restore command can they use? They can use database(only read) and apply the transaction log (log backups from our side).
If they use "with norecovery", then they can't use database;
If they use "with recovery", then they can't apply transaction log.
By the way, They can't use Log Shipping, Replication, Database Mirroring etc.
Thanks