HELP!... SQL Log Gone. How do I recover Database

As the subject says...
I will admit to some stupidity. I inadvertently deleted
the log file.
On top of that, it appears my backups have failed, so no
back up.
Data file still exists.
Please tell me there is a way to recover.
Thanks in advance.
SvenI would give MS PSS a call if it's important to get it back.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
But if all else fails here is something you can try:
http://www.sqlservercentral.com/scripts/scriptdetails.asp?scriptid=599
Restoring a .mdf
Andrew J. Kelly
SQL Server MVP
"Sven Hansen" <svenhansen@.shaw.ca> wrote in message
news:079001c3af02$a07d2fa0$a101280a@.phx.gbl...
> As the subject says...
> I will admit to some stupidity. I inadvertently deleted
> the log file.
> On top of that, it appears my backups have failed, so no
> back up.
> Data file still exists.
> Please tell me there is a way to recover.
> Thanks in advance.
> Sven|||If you have the data file, then you can bring back your
database by using "sp_attach_db" coomand.
Look in BOL, for syntax and more info. Its very easy.
Good Luck!
-SQLVarad (MCDBA-1999,MCSE-1999)
>--Original Message--
>As the subject says...
>I will admit to some stupidity. I inadvertently deleted
>the log file.
>On top of that, it appears my backups have failed, so no
>back up.
>Data file still exists.
>Please tell me there is a way to recover.
>Thanks in advance.
>Sven
>.
>|||Since you have only data file, use this syntax
Example:
EXEC sp_attach_db @.dbname = 'pubs',
'c:\Program Files\Microsoft SQL Server\MSSQL\Data\pubs.mdf'
SQL Server will automatically attach a new log file.
Good Luck!
SQLVarad (MCDBA-1999,MCSE-1999)
>--Original Message--
>As the subject says...
>I will admit to some stupidity. I inadvertently deleted
>the log file.
>On top of that, it appears my backups have failed, so no
>back up.
>Data file still exists.
>Please tell me there is a way to recover.
>Thanks in advance.
>Sven
>.
>|||You saved my life... and likely my job... :)
Thank you.
The script worked perfectly.
Take care and thanks again.
Sven
>--Original Message--
>I would give MS PSS a call if it's important to get it
back.
>http://support.microsoft.com/default.aspx?scid=fh;EN-
US;sql SQL Support
>http://www.mssqlserver.com/faq/general-pss.asp MS PSS
>But if all else fails here is something you can try:
>http://www.sqlservercentral.com/scripts/scriptdetails.asp
?scriptid=599
>Restoring a .mdf
>
>--
>Andrew J. Kelly
>SQL Server MVP
>
>"Sven Hansen" <svenhansen@.shaw.ca> wrote in message
>news:079001c3af02$a07d2fa0$a101280a@.phx.gbl...
>> As the subject says...
>> I will admit to some stupidity. I inadvertently
deleted
>> the log file.
>> On top of that, it appears my backups have failed, so
no
>> back up.
>> Data file still exists.
>> Please tell me there is a way to recover.
>> Thanks in advance.
>> Sven
>
>.
>

HELP!! i deleted services!

i have installed vs 2005 and sql server enterprise edition on an xp pro sp2 machine.but i could not connect to the mssqlexpress default database that it came with.in a moment of madness i deleted the mssqlserver services (3 of them).how do i reinstall them? i thought uninstalling the products and reinstalling them would help but it did not.

please help!

cheers OK, wait a minute. You installed the enterprise edition of the MSSQL Service on a XP prof ? This is not possible. What did you actually delete, where and what did you try to achieve ?

HTH, jens Suessmeyer.

http://www.sqlserver2005.de|||

yes it it is possible, the only thing is that you do not have access to all the functionality.i have solved the prob by uninstalling and installing the work edition.

thanks

|||Sorry to correct you, but installing SQL Server services won′t be available for enterprise edition, only the client tools.

Jens Suessmeyer.

http://www.sqlserver2005.de

Help!! i deleted mssqlserver services

i

have installed vs 2005 and sql server enterprise edition on an xp pro

sp2 machine.but i could not connect to the mssqlexpress default

database that it came with.in a moment of madness i deleted the

mssqlserver services (3 of them).how do i reinstall them? i thought

uninstalling the products and reinstalling them would help but it did

not.

please help!

cheers how did you delete them?|||Are you trying to connect using VS 2005?sql

HELP! restore database - left in loading state? PLEASE HELP!

Hi all-
I actually don't work in SQL Server administration but I am trying to restore a database. I am a developer. I deleted all the rows from one of the tables in a database and I need to get that particular table back. The people that actually do the restor
e for me tell me that the RESTORE part has completed, but now the database says "(loading)" and stays this way indefinitely! They are trying to restore the database to a temporary location on another server, so that we can then just take the ONE table th
at I need back and import it back over. No one seems to have any idea how to move beyond this "loading" state and access the tables. Does this sound familiar to anyone? Please help - this is production data!!!!!! Thanks so much!!!
Try:
restore database MyDB with recovery
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"KMZ_state" <KMZ_state@.discussions.microsoft.com> wrote in message
news:A9DCF94E-276C-4D74-BB22-D55FCD672461@.microsoft.com...
Hi all-
I actually don't work in SQL Server administration but I am trying to
restore a database. I am a developer. I deleted all the rows from one of
the tables in a database and I need to get that particular table back. The
people that actually do the restore for me tell me that the RESTORE part has
completed, but now the database says "(loading)" and stays this way
indefinitely! They are trying to restore the database to a temporary
location on another server, so that we can then just take the ONE table that
I need back and import it back over. No one seems to have any idea how to
move beyond this "loading" state and access the tables. Does this sound
familiar to anyone? Please help - this is production data!!!!!! Thanks
so much!!!
|||Try:
restore database MyDB with recovery
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"KMZ_state" <KMZ_state@.discussions.microsoft.com> wrote in message
news:A9DCF94E-276C-4D74-BB22-D55FCD672461@.microsoft.com...
Hi all-
I actually don't work in SQL Server administration but I am trying to
restore a database. I am a developer. I deleted all the rows from one of
the tables in a database and I need to get that particular table back. The
people that actually do the restore for me tell me that the RESTORE part has
completed, but now the database says "(loading)" and stays this way
indefinitely! They are trying to restore the database to a temporary
location on another server, so that we can then just take the ONE table that
I need back and import it back over. No one seems to have any idea how to
move beyond this "loading" state and access the tables. Does this sound
familiar to anyone? Please help - this is production data!!!!!! Thanks
so much!!!
sql

HELP! More deleted records!

I have a replicated database and hundreds of records keep "disappearing" from
one table in particular. The table is a child table storing the answers to a
number of questions. Also;
1. The tables have referential integrity enforced, with cascade delete.
2. The relationships are enforced for replication.
3. There are no stored procedures which delete records from the offending
table.
4. There is no way of manually deleting records directly from the offending
table using the front-end application.
5. The parent tables have exactly the same records in as previously.
6. There are no replication conflicts.
Any ideas?
I am keeping transaction logs for 3 weeks. Is there any way that I can find
out from the transaction logs when the records were deleted? Is there any way
I can find out why the records would have been deleted?
Thanks,
Nigel Taylor
http://www.tinit.co.uk/
Nigel,
you don't say if this is on the publisher or on the subscriber, but I'm
guessing the latter. It could be that some updates are replicated as a
delete-insert pair for transactional replication in ceertain cases (see
http://support.microsoft.com/default...NoWebContent=1).
Perhaps this is your case?
Also I'm not clear why you're using cascading constraints for the subscriber
which is normally treated as RO - or maybe I have misunderstood?
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi,
It's an ftp merge replication. I'm not sure where the records are
disappearing from first but the publisher is definately causing the other
subscribers (of which there are about 12) to lose the records too.
The relationships (i.e. cascade delete and enforce for replication) were
automatically created when the subscription was first created from the
publisher.
With the delete-insert pair the records would be recreated wouldn't they?
Thanks,
Nigel Taylor
http://www.tinit.co.uk/
|||In fact, when I use your spBrowseMergeChanges procedure on the offending
table, there are a load more records marked for deletion and without a
replacement!
Nigel Taylor
http://www.tinit.co.uk/
|||Nigel,
as you're using merge, and assuming you have all the related tables being
replicated, I'd modify all relationships to be not enforced for replication.
The delete-insert pairs are a problem for transactional and not merge, but
with merge there are other reasons the FK constraints are not applied (see
http://www.replicationanswers.com/Me...derArticle.asp). This
will simplify the setup somewhat and hopefully allow us to see if this is
the cause of the problems.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Okay, thanks Paul. I've removed the 'enforce relationship for replication'
flag and removed the cascade deletes on the offending tables. Hopefully it'll
work and I can get back to doing something else.
Cheers,
Nigel Taylor
http://www.tinit.co.uk/

HELP! I have deleted my LDF file

I have delated my transaction log file (it was 1,3 Gb big). I'm trying everything to recover my DB without success..
Does someone could help me
thanks a lot, GiovanniHi,
Did you detached the database and deleted the transaction log file, or just
stopped SQL server and deleted the file.
If you deleted the file after detaching then usethe system procedure to
attach the database with single MDF file. (Make it a try even if you
have deleted the file with out detach)
sp_attach_single_file_db 'DBNAME','location and filename of MDF file'
(Refer books online for more info
The command will fail incase if you have more than one LDF otr MDF file.
If you have mutiple MDF/LDF files you may need to restore from last
successful database backup or contact Microsot support.
Thanks
Hari
MCDBA
"Giovanni BO" <giovanni.gambaro@.businessobjects.com> wrote in message
news:955A7588-A85F-4DB4-BB2C-802780350503@.microsoft.com...
> I have delated my transaction log file (it was 1,3 Gb big). I'm trying
everything to recover my DB without success...
> Does someone could help me?
> thanks a lot, Giovanni

HELP! I have deleted my LDF file

I have delated my transaction log file (it was 1,3 Gb big). I'm trying every
thing to recover my DB without success...
Does someone could help me?
thanks a lot, GiovanniHi,
Did you detached the database and deleted the transaction log file, or just
stopped SQL server and deleted the file.
If you deleted the file after detaching then usethe system procedure to
attach the database with single MDF file. (Make it a try even if you
have deleted the file with out detach)
sp_attach_single_file_db 'DBNAME','location and filename of MDF file'
(Refer books online for more info
The command will fail incase if you have more than one LDF otr MDF file.
If you have mutiple MDF/LDF files you may need to restore from last
successful database backup or contact Microsot support.
Thanks
Hari
MCDBA
"Giovanni BO" <giovanni.gambaro@.businessobjects.com> wrote in message
news:955A7588-A85F-4DB4-BB2C-802780350503@.microsoft.com...
> I have delated my transaction log file (it was 1,3 Gb big). I'm trying
everything to recover my DB without success...
> Does someone could help me?
> thanks a lot, Giovanni

HELP! (Not sure if first one went.)

I have inadvertently deleted my log file.
This in turn has rendered the Data file unusuable, and
unattachable.
Any clues how I can fix this.
I would appreciate any and all input.
THank you
SvenRestore your latest backup?
--
David Portas
--
Please reply only to the newsgroup
--
"Sven" <svenhansen@.shaw.ca> wrote in message
news:07a301c3af03$b385d100$a101280a@.phx.gbl...
> I have inadvertently deleted my log file.
> This in turn has rendered the Data file unusuable, and
> unattachable.
> Any clues how I can fix this.
> I would appreciate any and all input.
> THank you
> Sven
>|||Ignore. Others have already answered in a previous thread.
--
David Portas
--
Please reply only to the newsgroup
--

Help! - My subscriptions are being deleted !?

Problem: My subscriptions are being deleted, I guess when i re-deploy the
reports?
It has happend twice, but I do not know the reason, It just seems to happen!
As of today, we use 6 different subscriptions, 3 of which produce 6000
reports to be distributed to email recipients, and 3 producing reports to a
shared disk.
As you can see, to reproduce the subscriptions tak some time!
Anyone with the same experience ?
Further info:
There are two devlopers developing in the same .NET 2003 report project, and
deploing to the same reporting services server. A C# application is developed
to add/delete subscriptions, but the deleted once is not reachable from the
application.
Greatful for any reply on this !Although I haven't tried to duplicate your problem,,, Is it possible that
sometimes you are deleting the report, then re-deploying it?
That will cause permissions, default parameters, subscriptions to go away,
even if you redeploy the report with the same name.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"frankiebody" <frankiebody@.discussions.microsoft.com> wrote in message
news:BF1285A1-5DB8-433E-A961-9791C3E77555@.microsoft.com...
> Problem: My subscriptions are being deleted, I guess when i re-deploy the
> reports?
> It has happend twice, but I do not know the reason, It just seems to
> happen!
> As of today, we use 6 different subscriptions, 3 of which produce 6000
> reports to be distributed to email recipients, and 3 producing reports to
> a
> shared disk.
> As you can see, to reproduce the subscriptions tak some time!
> Anyone with the same experience ?
> Further info:
> There are two devlopers developing in the same .NET 2003 report project,
> and
> deploing to the same reporting services server. A C# application is
> developed
> to add/delete subscriptions, but the deleted once is not reachable from
> the
> application.
> Greatful for any reply on this !
>
>|||Thanks for response !
I think i found the problem (I hope). The cleanup agent in SQL server is
running a session every 336 = 14 days. Cleaning/deleting all "expired"
subscriptions!
I've just alterede the procedure, removing the line actually performing the
deletion, from the procedyre "CleanExpiredSubscriptions"
I suppose I could sett a property to "0" somewhere to achieve the same
result, but I'm not sure where...
Frank Gryte
"Wayne Snyder" wrote:
> Although I haven't tried to duplicate your problem,,, Is it possible that
> sometimes you are deleting the report, then re-deploying it?
> That will cause permissions, default parameters, subscriptions to go away,
> even if you redeploy the report with the same name.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "frankiebody" <frankiebody@.discussions.microsoft.com> wrote in message
> news:BF1285A1-5DB8-433E-A961-9791C3E77555@.microsoft.com...
> > Problem: My subscriptions are being deleted, I guess when i re-deploy the
> > reports?
> > It has happend twice, but I do not know the reason, It just seems to
> > happen!
> > As of today, we use 6 different subscriptions, 3 of which produce 6000
> > reports to be distributed to email recipients, and 3 producing reports to
> > a
> > shared disk.
> >
> > As you can see, to reproduce the subscriptions tak some time!
> > Anyone with the same experience ?
> >
> > Further info:
> > There are two devlopers developing in the same .NET 2003 report project,
> > and
> > deploing to the same reporting services server. A C# application is
> > developed
> > to add/delete subscriptions, but the deleted once is not reachable from
> > the
> > application.
> >
> > Greatful for any reply on this !
> >
> >
> >
> >
>
>

help!

hi!
accidently I deleted a table from a database that has 1200 tables. I do not
want to restore the whole database, but just the table I deleted. I backup
the transaction log every hour. What should I do?
thanks,
Hi,
Do a POINT_IN_TIME Recovery... Still you have to restore the full database
backup in to a new database followed with transaction
log backups.
POINT_IN_TIME restore will work only if your Recovery mode is FULL for that
database.
If it is FULL then:-
1. Take a backup transaction log in current database
2. Create a new database
3. Restore with full backup file with NORECOVERY (Use below command)
RESTORE database new_dbname from disk='file' with NORECOVERY, MOve
'logical_mdf' to 'physical_mdf',
move 'logical_ldf' to 'physical_ldf'
4. Restore the transaction log backup taken in step-1 with RECOVERY and
STOPAT option
RESTORE log new_dbname from disk='tran_backup_file' with RECOVERY,
STOPAT= ''May 24, 2004 03:44 AM'
Thanks
Hari
MCDBA
"aoxpsql" <anonymous@.discussion.com> wrote in message
news:#FdiLZofEHA.3412@.TK2MSFTNGP11.phx.gbl...
> hi!
> accidently I deleted a table from a database that has 1200 tables. I do
not
> want to restore the whole database, but just the table I deleted. I backup
> the transaction log every hour. What should I do?
> thanks,
>