Friday, February 24, 2012

Database Recovery

I am having only mdf file and log file which is one week older .how can i restore the database.Is it possible to
restore the databaseIf you are lucky...
You can try sp_attach_single_file_db to attach the mdf file, but it is only
documented to work if you detached the database in the first place.
The log file is not usable in any way (as it is older than the database
file).
--
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"saravana" <saravana@.winsarinfo.com> wrote in message
news:CE22770B-A188-434A-9C4A-154DDED589F0@.microsoft.com...
> I am having only mdf file and log file which is one week older .how can i
restore the database.Is it possible to
> restore the database
>

No comments:

Post a Comment