No probs...that should serve you well..... :-) -----Original Message----- From: Cruz, Lisa L Ms GPRMC [mailto:[EMAIL PROTECTED]] Sent: 18 November 2002 16:08 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] SQL 2000-Transactions and Restore
Thanks Neil! That was an awesomely quick response! What I plan to do is put all of you all's suggestions in my Back-Up Plan book, for future reference. I am also going to try them to see if I can get Tuesdays data to come back... Thanks again, Lisa -----Original Message----- From: Robertson-Ravo, Neil (REC) [mailto:[EMAIL PROTECTED]] Sent: Monday, November 18, 2002 10:10 AM To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] SQL 2000-Transactions and Restore Yes, this should serve you : RESTORE DATABASE [YOURDATABASENAME] FROM [YOURDATABASEDATAFILE] WITH NORECOVERY GO RESTORE LOG YOURDATABASENAME FROM [YOURDATABASELOGFILE] WITH RECOVERY, STOPAT = 'Nov 10, 2002 09:00 AM' GO -----Original Message----- From: Cruz, Lisa L Ms GPRMC [mailto:[EMAIL PROTECTED]] Sent: 18 November 2002 15:58 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] SQL 2000-Transactions and Restore Importance: High Hi All, We had our production server go down last week. The tape drive back-up locked up and froze the RAID 5 array. The only thing we could think to do was reboot, pop the tape out, and get the server back up. Only the server was not amenable to this. In NetRaid Express Tools, we found only three hard drives listed (cuz of parity?). Drive 1 was found, no faults, online. Drive 2 was found, offline, one media error, and drive 3 was found, offline, with 9 media errors. I am pretty sure the media errors were from the tape drive... We are running SQL 2000 Server, Win 2K Server, and CF 5. We lost Tuesday's data, and had to basically rebuild the drives and OS. My round about question is this: In SQL 2000 Server, is there a way to go into transaction logs to be able to recover the data and images input to the server from a particular day? Or does just data get written to these logs? We are considering a mirror server, but are concerned about response time on the end-user side... Any suggestions(?) will be gratefully accepted....... Lisa Cruz Teledermatology System Administrator Office of Clinical Operations Great Plains Regional Medical Command 2410 Stanley Rd., Suite B-17 Ft Sam Houston, Texas 78234-6230 210-295-2705 DSN: 421-2705 Fax: 210-295-2345 DSN: 421-2345 -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
