472,090 Members | 1,293 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,090 software developers and data experts.

Restoring from transaction logs to running database

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
Feb 16 '07 #1
0 1096

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

10 posts views Thread by TZoner | last post: by
6 posts views Thread by Edwinah63 | last post: by
3 posts views Thread by Thiko | last post: by
2 posts views Thread by francois1 | last post: by
reply views Thread by Chloe C | last post: by
4 posts views Thread by Troels Arvin | last post: by
1 post views Thread by JA | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.