Restoring a database only from MDF and Log file

#1 (**permalink**) 02-28-2008, 06:38 PM

Hello.

Can anyone tell me if a SQL Server 2000 database can be
recovered only from the MDF and log files ?

I have no backups.

Thanks in advance

#2 (**permalink**) 02-28-2008, 06:38 PM

Hi

You may be able to use sp_attach_db see

http://msdn.microsoft.com/library/de...asp?frame=true

John

"Dave Pylatuk" <davep@centurysystems.net> wrote in message
news:Kf53b.10295$Cg2.788132@news20.bellglobal.com. ..
> Hello.
>
> Can anyone tell me if a SQL Server 2000 database can be
> recovered only from the MDF and log files ?
>
> I have no backups.
>
> Thanks in advance
>
>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode