July 2, 2002 at 2:55 am
I have two servers one housing a DLT drive and is running SQL 2000. I currently backup 3 DB's to this tape drive. I would like to backup a further 15 DB's on another server within the same domain to the same tape, appending the data, this server is also running SQL2000, does anyone have any clues? At present my sql script is as shows but unfortunately does not work:
BACKUP DATABASE Isis_Testmeta
TO TAPE = \\Tape0=\\testserver_04n\daily backups\ISIS_Testmeta_db_20026240201.bak
WITH noFORMAT,
NAME = 'Full Backup of Isis_Testmeta'
GO
Edited by - martinplant on 07/02/2002 05:02:47 AM
Edited by - martinplant on 07/02/2002 05:03:24 AM
July 2, 2002 at 9:48 am
AFAIK, you cannot backup to a remote tape. Can you backup to a drive on the tape server and then use the Backup utility to get these files?
Steve Jones
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply