Missing log file...

Hi,
OK - I did stupid thing but... ;-)
I put database offline and then I deleted log file.
Then I was surprised that database do not want to
go into on-line status...
I am interested in object of this db not in data.
Is there any hope?
(I know - for me - not, but for this database? ;-)
RadekHi,
You might loose the consistency if you delete the LDF file directly.. Since
you are not that bothered bothered about data you could try
1. Try to attach the database using
EXEC sp_attach_single_file_db @.dbname = 'pubs', @.physname ='D:\MSSQL\data\dbname.mdf'
This will attach the database with MDF file and will create a new LDF file.
This command will fail some times, since you have not detached the database
properly.. in that use the below method
2.
1. Create a new database with the same name and same MDF and LDF files
2. Stop sql server and rename the existing MDF to a new one and copy the
original MDF to this location and delete the LDF files.
3. Start SQL Server
4. Now your database will be marked suspect
5. Update the sysdatabases to update to Emergency mode. This will not use
LOG files in start up
Sp_configure "allow updates", 1
go
Reconfigure with override
GO
Update sysdatabases set status = 32768 where name = "BadDbName"
go
Sp_configure "allow updates", 0
go
Reconfigure with override
GO
6. Restart sql server. now the database will be in emergency mode ( You
could access the database)
7. Use enterprise manager to script all your objects
Thanks
Hari
MCDBA
"Radek" <radek@.obecniezwarszawy.pl> wrote in message
news:cfv1kb$4r3$1@.nemesis.news.tpi.pl...
> Hi,
> OK - I did stupid thing but... ;-)
> I put database offline and then I deleted log file.
> Then I was surprised that database do not want to
> go into on-line status...
> I am interested in object of this db not in data.
> Is there any hope?
> (I know - for me - not, but for this database? ;-)
> Radek
>|||Before you do Hari's 2nd option make sure you copy off your original MDF
first...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Radek" <radek@.obecniezwarszawy.pl> wrote in message
news:cfv1kb$4r3$1@.nemesis.news.tpi.pl...
> Hi,
> OK - I did stupid thing but... ;-)
> I put database offline and then I deleted log file.
> Then I was surprised that database do not want to
> go into on-line status...
> I am interested in object of this db not in data.
> Is there any hope?
> (I know - for me - not, but for this database? ;-)
> Radek
>|||I agree with Wayne...Thanks for pointing out.
Thanks
Hari
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OOIrMERhEHA.3964@.TK2MSFTNGP12.phx.gbl...
> Before you do Hari's 2nd option make sure you copy off your original MDF
> first...
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "Radek" <radek@.obecniezwarszawy.pl> wrote in message
> news:cfv1kb$4r3$1@.nemesis.news.tpi.pl...
> > Hi,
> >
> > OK - I did stupid thing but... ;-)
> > I put database offline and then I deleted log file.
> > Then I was surprised that database do not want to
> > go into on-line status...
> > I am interested in object of this db not in data.
> > Is there any hope?
> > (I know - for me - not, but for this database? ;-)
> >
> > Radek
> >
> >
>|||> 1. Try to attach the database using
> EXEC sp_attach_single_file_db @.dbname = 'pubs', @.physname => 'D:\MSSQL\data\dbname.mdf'
>
It works :)
I was sure that something like this command should exist
... but I couldn't find it in manuals.
Thank You
Radek