November 2, 2015 at 9:41 am
Hi Team,
I have taken a compressed online backup of one database. The database size came from 360GB to 190GB.
Now i want to restore the compressed backup which should replace as 190GB.
But when i try to restore it was coming as 360GB.
Is it possible to do the restore in that way. If yes could i have the script to restore.
Thank you
Regards
Raghu
November 2, 2015 at 10:04 am
sraghunandana.6 (11/2/2015)
Hi Team,I have taken a compressed online backup of one database. The database size came from 360GB to 190GB.
Now i want to restore the compressed backup which should replace as 190GB.
But when i try to restore it was coming as 360GB.
Is it possible to do the restore in that way. If yes could i have the script to restore.
Thank you
Regards
Raghu
Doesn't work that way, the backup compression is like zipping a file, uncompressing is then the equivalent of the restore. The database will be exactly the same size as the original after the restore.
😎
November 2, 2015 at 10:07 am
Thanks a lot for quick response .
So now i should ask our Infra team to add some extra space before i restore.
Regards
Raghu
November 2, 2015 at 1:07 pm
sraghunandana.6 (11/2/2015)
So now i should ask our Infra team to add some extra space before i restore
That would be a really good idea 😉
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply