February 28, 2009 at 5:35 am
Hi All,
I tried running the below command in the query analyser to take a backup straight to tape drive.
BACKUP DATABASE MASTER TO TAPE='\\.\TAPE0' WITH NAME='MASTER COMPLETE', NOUNLOAD
The event viewer log shows the backup is successfull.
++++++++++++++++++++++++++
Database backed up: Database: ReportServer, creation date(time): 2008/10/06(14:22:33), pages dumped: 4400, first LSN: 167:3533:1, last LSN: 167:3535:1, number of dump devices: 1, device information: (FILE=1, TYPE=TAPE: {'\\.\TAPE0'}).
++++++++++++++++++++++++++
but when i try to retrieve the data from the tape, I can see only NO ENTRIES FOUND. The restore report shows 0 files and directory
-----------------------------------------
Restore started on 2/26/2009 at 7:38 PM.
Restore completed on 2/26/2009 at 7:38 PM.
Directories: 0
Files: 0
Bytes: 0
Time: 5 seconds
-------------------------------------------
Could somebody enlight me where exactly things going wrong
Thanks,
Gopi
NOTE: By mistake i posted in sql 2005 forum so i tried to delete it. dont know if that has updated. anyway am again posting in the right place.
March 2, 2009 at 9:52 am
I'm not sure what is wrong, but how are you retrieving the backups from tape? There should be a header that you can read with the RESTORE HEADERONLY.
Also, it's recommended to back up to disk and then move to tape. Tape is inherently slower, more fragile, and more likely to cause you issues.
I'll delete the 2005 post
March 3, 2009 at 12:16 am
Hi Steve Jones,
Thanks for the reply. yes you can delete the 2005 post. I tried to delete it but but couldn't.
I cannot store the backup in the local disk as there is no space. C drive has 50 GB space but i been told not to use system drive. I have 26 GB free in D:\ Drive but the DB is around 40 GB.
The sql service is running in "system account" rights therefore i was not able to take backup to a shared network drive.
Again i been told not to change to domain account as this will affect the 2500 BPO agents logged into the system .
so i was left with no other option except to take the backup straight to tape drive.
||||||||||||I'm not sure what is wrong, but how are you retrieving the backups from tape? There should be a header that you can read with the RESTORE HEADERONLY.||||||||||||||||
i tried retrieving the db from the tape using ntbackup. I did not use the RESTORE command because of the sensitivity of the command. is it possible to run a command so that the file can be stored to a local disk straight from the tape without affecting the present databse ???
Thanks,
Gopi
March 6, 2009 at 10:22 am
I don't think you can move the file from the tape to disk. I could be wrong here.
The RESTORE WITH HEADERONLY should return results, no overwriting things.
Honestly, a USB drive doesn't cost a lot. Ask someone to get one, it really helps to have space available for backups. And if this is important, you need the space for backups.
The database size doesn't necessarily = backup size. Only the data is backed up. Free space in the database isn't included in the backup file.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply