Re: Deleted Transaction Logs!

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Jose Ines Cantu Arrambide (joseine_at_nospam.com)
Date: 04/07/04 

Date: Wed, 7 Apr 2004 14:38:21 -0600

You will loose any uncomitted data and anything after the last CHECKPOINT,
do you have your recovery model full or simple? If its simple I think you
loose less.

You can also create a new database with the same name, stop sql service and
replace the data files with your original database and then start the
service again. If this didnt work set the database to emergency mode and
then try to copy objects using DTS to a new database.

"Gary" <gary.rey@virtium.NOSPAM.com> wrote in message
news:uZUp64MHEHA.2668@TK2MSFTNGP10.phx.gbl...
> is it safe to delete these files? I wont lose core data will I?
>
> -Gary
>
> "Gary" <gary.rey@virtium.NOSPAM.com> wrote in message
> news:endeRjMHEHA.2472@TK2MSFTNGP10.phx.gbl...
> > I accidentalty deleted the transaction logs on a DB I had, and now I can
> get
> > it up on SQL enterprise, any ideas?
> >
> > -Gary
> >
> >
>
>

Relevant Pages

  • Re: PC joining domain
    ... If you loose a DC without demoting you have to do some steps to remove it complete from the AD database, DNS zones, AD sites and services: ...
    (microsoft.public.windows.server.active_directory)
  • Re: Deleted Transaction Logs!
    ... > You will loose any uncomitted data and anything after the last CHECKPOINT, ... > You can also create a new database with the same name, ... > replace the data files with your original database and then start the ... If this didnt work set the database to emergency mode and ...
    (microsoft.public.sqlserver.server)
  • Re: backing up WM database
    ... ReCom wrote: ... I wish microsoft would make it easier to back up the database, its so much work to build it, and so easy to loose it if you have to do a restore or rebuild, as if that isnt enough work and headache in itself. ...
    (microsoft.public.windowsmedia)
  • Re: Deleted Transaction Logs!
    ... >> You will loose any uncomitted data and anything after the last ... >> You can also create a new database with the same name, ... If this didnt work set the database to emergency mode and ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2005 Best Practice vs SQL 2000: Application Files Separate from data (and log) files
    ... You'll not be using most of the system databases intensively so you don't need to seperate them, I mean locating them on different physical disks. ... If it's being used intensively in your environment then you should locate it's log and data files on different physical disks. ... For this question you must understand the reason why we should seperate data and log files. ... Of course these drives must be physically seperated so that you'll gain performance benefits. ...
    (microsoft.public.sqlserver.setup)