469,958 Members | 1,914 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

backing up read-only database

I am using log shipping. I want to be able to backup the secondary
read-only database. The data has to travel over a t1, and due to the
size of the databases, it saturates the network. Our tape backup system
resides at the secondary location (our offices), and we want to backup
the fulls to tape, so we either copy the fulls over the wire, or backup
the secondary databases, directly to the tape backup share on the local
net.

Is there a way to backup read-only databases? Can you backup databases
that have been restored "with recovery" instead of "with standby"?. I
can't find documentation about this online, or in the books.

Thanks,

TGru

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 23 '05 #1
0 1025

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

12 posts views Thread by Steven T. Hatton | last post: by
5 posts views Thread by Stewart Graefner | last post: by
1 post views Thread by Martin Schmid | last post: by
reply views Thread by Martin Schmid | last post: by
2 posts views Thread by Jared | last post: by
9 posts views Thread by Robinson | last post: by
12 posts views Thread by jim | last post: by
reply views Thread by =?ISO-8859-1?Q?J=F6rg_Battermann?= | last post: by
reply views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.