I have nightly backups that back up sql 2000 databases on disk. We also have
third party software backups on tape. What happens occasionally is the tape
backup hangs on something, then disk backups don't complete because they are
waiting on the tape to complete. Can the tape backups grab the file backups
without requiring exclusive access to DBs? any other suggestion are
appreciated
Thanks
Sorry, I sent my reply to the wrong place.
"Niles" wrote:
> I have nightly backups that back up sql 2000 databases on disk. We also have
> third party software backups on tape. What happens occasionally is the tape
> backup hangs on something, then disk backups don't complete because they are
> waiting on the tape to complete. Can the tape backups grab the file backups
> without requiring exclusive access to DBs? any other suggestion are
> appreciated
> Thanks
|||Per BOL:
table variables used in stored procedures result in fewer recompilations of
the stored procedures than when temporary tables are used.
"Niles" wrote:
> I have nightly backups that back up sql 2000 databases on disk. We also have
> third party software backups on tape. What happens occasionally is the tape
> backup hangs on something, then disk backups don't complete because they are
> waiting on the tape to complete. Can the tape backups grab the file backups
> without requiring exclusive access to DBs? any other suggestion are
> appreciated
> Thanks
|||"Niles" <Niles@.discussions.microsoft.com> wrote in message
news:248F46BC-9AF6-4F94-8666-5BE954ABCC54@.microsoft.com...
> I have nightly backups that back up sql 2000 databases on disk. We also
have
> third party software backups on tape. What happens occasionally is the
tape
> backup hangs on something, then disk backups don't complete because they
are
> waiting on the tape to complete. Can the tape backups grab the file
backups
> without requiring exclusive access to DBs? any other suggestion are
> appreciated
I wouldn't bother with the tape backups.
Backup to disk and then backup THAT file to tape.
> Thanks
sql
没有评论:
发表评论