469,313 Members | 2,550 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,313 developers. It's quick & easy.

Restoring from transaction logs to running database

1
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 1015

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
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
reply views Thread by harlem98 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.