February 12, 2011 at 8:00 pm
Hi,
We have two issues in backup/restoration.
01. Our primary database size is about 4tb. We are not able to take the backup to tape as the tape size is 3.5tb. Is there anyway we can fire the backup from MSSQL to multiple tapes without any third party tool.
02. In DR site, the database in recover mode, now we wants to re-align the storage to add further space. Is there any way, without restoration again, can we bring the db down and do the re-alignment and start the log applying again. De-attach and attach will open the db in DR. We wants without opening the database, is there any way to re-start the log shipping.
Appreciate your response.
Regards,
Iyyappan
February 12, 2011 at 11:57 pm
01. Our primary database size is about 4tb. We are not able to take the backup to tape as the tape size is 3.5tb. Is there anyway we can fire the backup from MSSQL to multiple tapes without any third party tool.
You can split a backup across multiple files however I'm not sure about doing it to different tapes. I do not use tape drives but would imagine if the SQL Server instance sees the tape device you should be able to tell it which tape it should go to.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 13, 2011 at 8:15 am
A backup that large directly to tape is going to take forever. Do you have multiple file groups you can backup from? That would probably work better.
At your size of database, I'd look into a 3rd party product like Red Gate SQL Hyperbac[/url]. It's really going to make your life easier.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 13, 2011 at 11:02 pm
Hi Grant Fritchey,
Thanks for your suggestion, But I already tried Red Gate some time back. I dropped this software due to following issues.
01. Not able to restore if the structure of the drives are different. If my primary db is on D and F drives, while restoring the same database on different server, it is asking for the same D and F drive. But we may need to restore it on different drives. So it is looking for a physical standby db wherein we wanted to restore it on logical standby db.
02. If i convert the file types hbc or hbc2 to native sql server format (.bak), it is asking for same space of the db size and not in compressed format. Hence if my db size 1tb and if i want to convert to native format, i need similar size of 1tb space to convert. But compression works well with hbc and hbc2 format.
If you had tried the above two options and successful, then please let me know your views.
Regards,
Iyyappan
February 13, 2011 at 11:12 pm
do you really need full backup or differential backup can be considered?
----------
Ashish
February 13, 2011 at 11:16 pm
Hi,
Atleast two days in a week i should take full backup...Also particularly the backup has to be taken on to tape and also i should be able to restore the backup irrespective of drive structure of the target server where i'm going to restore the backup.
Regards,
Iyyappan
February 13, 2011 at 11:26 pm
01. Not able to restore if the structure of the drives are different. If my primary db is on D and F drives, while restoring the same database on different server, it is asking for the same D and F drive. But we may need to restore it on different drives. So it is looking for a physical standby db wherein we wanted to restore it on logical standby db.
But while doing the restoration, you can mention where you want to restore your database in 'restore as' option. There you can modify the directory structure.
----------
Ashish
February 13, 2011 at 11:29 pm
I'm talking about third party software Red Gate....hope you have seen my previous messages..
Regards,
Iyyappan
February 14, 2011 at 6:07 am
iyyappan.murugappan (2/13/2011)
Hi Grant Fritchey,Thanks for your suggestion, But I already tried Red Gate some time back. I dropped this software due to following issues.
01. Not able to restore if the structure of the drives are different. If my primary db is on D and F drives, while restoring the same database on different server, it is asking for the same D and F drive. But we may need to restore it on different drives. So it is looking for a physical standby db wherein we wanted to restore it on logical standby db.
02. If i convert the file types hbc or hbc2 to native sql server format (.bak), it is asking for same space of the db size and not in compressed format. Hence if my db size 1tb and if i want to convert to native format, i need similar size of 1tb space to convert. But compression works well with hbc and hbc2 format.
If you had tried the above two options and successful, then please let me know your views.
Regards,
Iyyappan
Thanks for the feedback. Yeah, on #2, when you got to uncompress, you have to have that room available. sorry.
On #1, I can absolutely move the files around with no issues on the restore. I tried it a couple of different ways. Since you use native commands for the backup and restore, there's nothing really you have to do special to make the MOVE work. I'd be curious how you hit that one because I can't replicate it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
February 14, 2011 at 1:07 pm
iyyappan.murugappan (2/13/2011)
Hi Grant Fritchey,Thanks for your suggestion, But I already tried Red Gate some time back. I dropped this software due to following issues.
01. Not able to restore if the structure of the drives are different. If my primary db is on D and F drives, while restoring the same database on different server, it is asking for the same D and F drive. But we may need to restore it on different drives. So it is looking for a physical standby db wherein we wanted to restore it on logical standby db.
02. If i convert the file types hbc or hbc2 to native sql server format (.bak), it is asking for same space of the db size and not in compressed format. Hence if my db size 1tb and if i want to convert to native format, i need similar size of 1tb space to convert. But compression works well with hbc and hbc2 format.
If you had tried the above two options and successful, then please let me know your views.
Regards,
Iyyappan
For #1, I have had this problem with BackUp Exec, but no problem with Redgate or Idera. You could get new demo software from them for a trial period and try again, since new versions will have new features such as object level restore. If good, you can then put a compressed full backup on your tape.
Viewing 10 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply