April 15, 2008 at 6:15 am
Hi all,
I had a database on web server. For upgrade, I took backup of database on my local machine and a success message was displayed (I trust, backup was taken physically). My database was removed from webserver, now I forgot the path and trying to search backup file with bak, mdf, ndf, mdb extension (though, I had not given the extension while saving). Please help otherwise I have to write the whole database again which will take at least 2 months.
Thanks and Regards,
Neeraj Kumar
April 15, 2008 at 6:32 am
search for .bkf files
April 15, 2008 at 7:17 am
Search for files modified on a certain date, asuming you know when the backup was taken. If you specified a file destination without an extension, I do not believe a default will be added.
-- You can't be late until you show up.
April 15, 2008 at 7:24 am
Thanks for reply but no luck in both methods. I have tried for the date of backup but still not getting 🙁
April 15, 2008 at 7:29 am
Hi
The Enterprise Manager or Management Studio that you used to run the backup - can you still use this software or is it on another machine?
Normally when you try run a backup - it displays the last used filename etc...
If you know the name of the file search for a name like - mydbname*.*
(If you think you have deleted the file - you could use a tool such as restoration to search deleted files on disk?)
Let us know how it goes
Thanks
Kevin
April 15, 2008 at 7:41 am
check backupjobhistory in msdb to find some clue
April 15, 2008 at 7:41 am
If when the database was deleted you told it not to delete the backup history you may be able to use....
use msdb
go
select bs.database_name,bmf.physical_device_name from backupmediafamily bmf
join backupset bs on (bs.media_set_id=bmf.media_set_id)
order by backup_start_date desc
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply