Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
franco
Constraint Violating Yak Guru
255 Posts |
 Posted - 2006-09-22 : 10:58:31
|
For this time, I don't have a question but I would like to let you know that a "point in time restore" was succesfully  performed today on our production SQL Server 2K.I can also confirm that QA is the way to go because EM don't works well with "point in time". I had to restore and recover from the last backup of yesterday (21 PM), plus all the t-logs performed every hours from 7 AM until 15.15 PM.Happy to see for real, in a production environment that it works!Thank you for all the answers and the suggestions you gave to me during this years.This forum is a precious tool to have.Cheers.Franco |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2006-09-22 : 12:45:27
|
Great! congrats!And welcome to the "QA is the way to go" camp  rockmoose |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2006-09-23 : 03:48:13
|
| "I can also confirm that QA is the way to go because EM don't works well with "point in time""I also find the EM is slow to bring up the list of available backups, and usually a restore-to-point-in-time is a very urgent request, so any avoidable delay saving is worth having.Now go and tell your manage how the good systems your company has in place saved the day - lest they decide that its all a piece of cake and cut costs in next weeks meeting!Kristen |
|
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2006-09-24 : 10:23:51
|
| How did you do it in qa.....any chance of posting your script.Whats your database on full .So you had x number of log files.I never did a restore from log files only ever from bak and all our databases are in simple...Cheers |
|
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Restore point in time...successfull!!!!!!!