There is a server in a remote location. We receive a full .bak of this database to restore on our server, where we use the data for a seperate purpose. The .BAK file is almost 3GB - zipped! They also send us transaction logs 2x / day. We would like to use those, and not download the full .BAK every night.
Is it possible (how?) to "update" our version of the live database by just applying the transaction logs, and not have to begin with the full .BAK... We would like to simply update / append the transactions to our version of the database (which we read from only - no updates)
We are running SQL Server 2005
Any help would be greatly appreciated. Thanks
Is it possible (how?) to "update" our version of the live database by just applying the transaction logs, and not have to begin with the full .BAK... We would like to simply update / append the transactions to our version of the database (which we read from only - no updates)
We are running SQL Server 2005
Any help would be greatly appreciated. Thanks