Viewing 7 posts - 16 through 22 (of 22 total)
Again let me explain :
1. A dtabase sists in a prod environment
2. This db does not have a master backup
3. On 6/18 data was deleted accidently.
4. I copied the mdf...
June 23, 2008 at 4:26 pm
Hello
Getting a copy of the original transaction log is no problem.
It is not trunacted. I can always get a copy from the prod server.
The size of my transaction log...
June 23, 2008 at 2:24 pm
Sorry it did not work. Throws an error. See the command I use and the msg below.
RESTORE DATABASE Reporting
FROM DISK = 'C:\Reporting\Reporting.BK'
WITH STOPAT = N'06/18/2008 5:23:36 PM'
I get...
June 23, 2008 at 1:02 pm
Thanks
See whether you would agree with the following ?
RESTORE DATABASE Northwind
FROM DISK = 'C:\Backups\Northwind_Full_20080623.BAK'
WITH NORECOVERY
RESTORE LOG Northwind
FROM DISK = 'C:\Backups\Northwind_Log_20080623.BAK'
WITH STOPAT = N'06/18/2008 6:23:36 PM'
Note: I...
June 23, 2008 at 10:43 am
So basically, here is what I got.
1. Look for a SQl server log parser.
2. Download, install and run against the live database.
3. Use the tool to extract data from the...
June 23, 2008 at 9:56 am
Sorry folks:
I guess I have not explained this properly. Lets put it this way.
1. DB created on June 1 2008.
2. Users add data, modify do what ever.......
June 23, 2008 at 9:28 am
Thanks
1. I do have the original mdf file
2. I have the original ldf file.
Regerdless of the backup status, I can recreate the databse ( I mean by using the for...
June 23, 2008 at 9:11 am
Viewing 7 posts - 16 through 22 (of 22 total)