Server failure

[Proli]

Hi,

I have lost my win 2k server where I had my Sql 2000 data.

Now I need to attach to sql server my database, but I have lost the log
file.

If I use the enterprise manager I get an error, if I use a stored
procedure I get an error.

How can I do to attach my .mdf file to Sql Server?

Thanks in advance

Marco Dell'Oca

[Dan Guzman]

A database might not attach if it wasn't properly detached. You can try
running sp_attach_single_file_db from Query Analyzer, specifying the path to
your database file. If this doesn't work, you best option is to restore
from backup.

If you have no backups, contact Microsoft PSS for assistance. They may be
able to help you salvage data but data integrity will be questionable
without the log.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"Proli" <in**@proli.it> wrote in message
news:AI********************@news4.tin.it...

Hi,

I have lost my win 2k server where I had my Sql 2000 data.

Now I need to attach to sql server my database, but I have lost the log
file.

If I use the enterprise manager I get an error, if I use a stored
procedure I get an error.

How can I do to attach my .mdf file to Sql Server?

Thanks in advance

Marco Dell'Oca

[Greg D. Moore \(Strider\)]

"Proli" <in**@proli.it> wrote in message
news:AI********************@news4.tin.it...

Hi,

I have lost my win 2k server where I had my Sql 2000 data.

Now I need to attach to sql server my database, but I have lost the log
file.

If I use the enterprise manager I get an error, if I use a stored
procedure I get an error.

How can I do to attach my .mdf file to Sql Server?
There's a method, but you need to contact MS SUpport.

Note that if you have unresolved transactions (i.e. the server died in the
middle of doing stuff) you will now have inconsistent data.


Thanks in advance

Marco Dell'Oca

[Simon Hayes]

"Proli" <in**@proli.it> wrote in message news:<AI********************@news4.tin.it>...

Hi,

I have lost my win 2k server where I had my Sql 2000 data.

Now I need to attach to sql server my database, but I have lost the log
file.

If I use the enterprise manager I get an error, if I use a stored
procedure I get an error.

How can I do to attach my .mdf file to Sql Server?

Thanks in advance

Marco Dell'Oca

At this point, your only real options are to restore from backup if
you have one, or call Microsoft PSS, who may be able to help you
recover data from the file.

Simon