February 15, 2011 at 10:09 am
Can some one please send me the steps to restore the TDE database on same server. This will be a point in time recovery.
February 15, 2011 at 10:19 am
books online will have all the examples you need to start with.
topic "restore"
When using sql server management studio, you can also have it restore your database to a new name and specify a point in time to restore to.
(right click on the database name and choose "tasks - restore")
You can then just generate the script by clicking on the "script" icon.
(just make cure you click "cancel" afterward, or it will launch the restore)
Take your time to prepare your restore action.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 15, 2011 at 10:19 am
Same steps as recovering any database to a point-in-time, I would guess. I don't know what "the TDE" database is, though.
Restore from the appropriate Full backup, using the With NoRecovery option so logs can be restored.
Restore any appropriate Diff, depending on your backup/restore plan, again using NoRecovery.
Restore all appropriate log files to the appropriate point-in-time.
You can probably do this by right-clicking the database in Management Studio, selecting Tasks/Restore and then picking the point in time you want, and letting the wizard pick the options you need. That's the easiest way to do it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
February 15, 2011 at 11:00 am
I am asking about the encrypted database backup. TDE is transparent database encryption.
February 15, 2011 at 11:01 am
I am asking about encrypted database restoration on same server as disaster recovery.
February 15, 2011 at 11:18 am
To restore a backup of an encrypted database to the same server it originated from, it's the same as any other restore because the certificate needed to decrypt it already exists on the server.
You can look here for more info:
February 15, 2011 at 11:19 am
If it is on the same server the database was encrypted on I don't believe you have to do anything.
You can read this article on SSC: Transparent Data Encryption (TDE) SQL Server 2008[/url]
The bottom of the article he restores the test database that had TDE enabled and does not have any special command in it that I can tell.
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
February 15, 2011 at 11:22 am
did you try a google search?
The keywords "restore from TDE database backup" returned several useful links, including this one.
SSC - your Simple Search Community.
February 16, 2011 at 12:09 am
hydbadrose (2/15/2011)
... restore the TDE database on same server....
this is the obscure part ... I interpreted it as database name, not encryption related.
You can have more than one database TDE-encrypted database on an instance, not necessarily encrypted by the same certificate !
anyway, by now you have enough replies and ref to know how to restore it.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply