Is there any possibilty that without going to secondary site I can restore the DB?

Question

Post reply

Is there any possibilty that without going to secondary site I can restore the DB?

Viewing 10 posts - 16 through 24 (of 24 total)

You must be logged in to reply to this topic. Login to reply

forsqlserver SSCoach Points: 18902 More actions · Answer 1

2008 R2

Are u sure Backup compression is not used in 2008?

Thanks

Brandie Tarvin SSC Guru Points: 173061 More actions · Answer 2

forsqlserver (7/28/2011)
2008 R2
Are u sure Backup compression is not used in 2008?

1) Please don't use text or L33T speak in the forums. There's enough acronyms and such flying around these forums just from the technospeak. Shortening your words just makes you hard to understand.

2) He didn't say backup compression wasn't used in 2008. He said 2008 Enterprise version used it. Standard doesn't have compression capabilities in 2008.

Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

forsqlserver SSCoach Points: 18902 More actions · Answer 3

forsqlserver

SSCoach

Points: 18902

July 28, 2011 at 5:52 am

#1359964

OOps!!My Misunderstanding

Thanks

chandan_jha18 SSChampion Points: 11330 More actions · Answer 4

Ignacio A. Salom Rangel (7/28/2011)
chandan_jha18 (7/28/2011)
Ignacio A. Salom Rangel (7/28/2011)
chandan_jha18 (7/28/2011)
Ignacio A. Salom Rangel (7/28/2011)
Mike's tip is very good. In case you don't have SQL 2008 Enterprise of SQL 2008 R2, you can still compress the backup.
In 2008 R2, even standard edition can compress the backups. This is the reason I asked the user to try using SQL backup.
that is why I said "SQL 2008 Enterprise or SQL 2008 R2", I did not mentioned anything about the version of SQL 2008 R2.
I did not understand what you wanted to say here.Can you please explain.
Chandan, as you mentioned SQL 2008 R2 supports backup compression on the standard, enterprise and datacenter edition, but 2008 does not supported on the standard edition, that is why I did not mention which version of SQL Server 2008 R2 could be use for backup compression. I hope it is clear to you now. 😉
Also, since you are fairly new to all this, I suggest that if you are trying something on a production server, get help from some expert in person or try to find someone in your social circle. I really do not suggest you to try anything on production
Did you direct that comment to me?

I was just mentioning that 2008 R standard edition supports backup compression.

And no my Lord. That comment was not directed to you. I am sure that you have been working with these technologies when I was learning to spell 'technology':-P in my school . I am still a kid trying to learn from you guys.

I was asking the original question poster boy to seek help from some expert from his circle. I just want him to be safe as far as his production databases are concerned.

chandan_jha18 SSChampion Points: 11330 More actions · Answer 5

forsqlserver (7/28/2011)
2008 R2
Are u sure Backup compression is not used in 2008?

As you stated that you are on 2008 R2, you can try compressing the backup and see how much size it comes to. Also, i mentioned in my previous posts that while taking the full backup you can split them into 4-5 files for easier copying. Did you try any of these?

forsqlserver SSCoach Points: 18902 More actions · Answer 6

forsqlserver

SSCoach

Points: 18902

July 28, 2011 at 6:08 am

#1359988

I will....

Thanks

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 7

forsqlserver (7/28/2011)
2008 R2
Are u sure Backup compression is not used in 2008?

SQL Server 2008 does not support backup compression on standard edition.

My blog

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 8

chandan_jha18 (7/28/2011)
I was just mentioning that 2008 R standard edition supports backup compression.
And no my Lord. That comment was not directed to you. I am sure that you have been working with these technologies when I was learning to spell 'technology':-P in my school . I am still a kid trying to learn from you guys.

I'm not that old 😉

I was asking the original question poster boy to seek help from some expert from his circle. I just want him to be safe as far as his production databases are concerned.

That is a good advice, but sometimes you don't have more help and that is when the community jumps in!

My blog

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 9

Brandie Tarvin (7/28/2011)

forsqlserver (7/28/2011)
2) He didn't say backup compression wasn't used in 2008. He said 2008 Enterprise version used it. Standard doesn't have compression capabilities in 2008.

Thanks for clarifying!

My blog

Ignacio A. Salom Rangel SSC-Insane Points: 20443 More actions · Answer 10

chandan_jha18 (7/28/2011)
As you stated that you are on 2008 R2, you can try compressing the backup and see how much size it comes to. Also, i mentioned in my previous posts that while taking the full backup you can split them into 4-5 files for easier copying. Did you try any of these?

Excellent advice!

My blog