HELP HELP!

Hi All,
How do bring back the database that says
databasename(recovering)?
Thanks,
TonyIf it is recovering it's best to leave it until it finishes. Is there any
indication that it is recovering, disk activity etc, or do you think it's
stuck..?
--
HTH
Ryan Waight, MCDBA, MCSE
"Tony" <tonymailbox2001@.yahoo.com> wrote in message
news:24cd901c38d27$f9c0f800$a601280a@.phx.gbl...
> Hi All,
> How do bring back the database that says
> databasename(recovering)?
> Thanks,
> Tony

Help - Recovering SQL 2000 Database

Friends,
The SQL server 2000 was running fine until all of a Sudden I got this
message,
SQL Server is aborting. Fatal exception c0000005 caught.
The Service would not start, and I need help in Recovering it.
Any help is greatly Appreciated.
Santosh
Can you check the SQL Server error log and post the error messages here? You
will find the log in MSSQL\Log folder under the installation path.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
news:eHXmsUcmEHA.3352@.TK2MSFTNGP10.phx.gbl...
> Friends,
> The SQL server 2000 was running fine until all of a Sudden I got this
> message,
> SQL Server is aborting. Fatal exception c0000005 caught.
> The Service would not start, and I need help in Recovering it.
> Any help is greatly Appreciated.
> --
> Santosh
>
|||Hi Vyas,
Sorry for the late reply,
The error log just says the below and halts at the last step.
2004-09-13 17:09:54.39 spid11 Starting up database 'jennifertest'.
2004-09-13 17:10:02.75 spid3 Recovery complete.
2004-09-13 17:10:02.75 spid3 SQL global counter collection task is
created.
Do you want any other file like SQLDump?
TIA
Santosh
Can you check the SQL Server error log and post the error messages here? You
will find the log in MSSQL\Log folder under the installation path.
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
news:eHXmsUcmEHA.3352@.TK2MSFTNGP10.phx.gbl...
> Friends,
> The SQL server 2000 was running fine until all of a Sudden I got this
> message,
> SQL Server is aborting. Fatal exception c0000005 caught.
> The Service would not start, and I need help in Recovering it.
> Any help is greatly Appreciated.
> --
> Santosh
>

Help - Recovering SQL 2000 Database

Friends,
The SQL server 2000 was running fine until all of a Sudden I got this
message,
SQL Server is aborting. Fatal exception c0000005 caught.
The Service would not start, and I need help in Recovering it.
Any help is greatly Appreciated.
--
SantoshCan you check the SQL Server error log and post the error messages here? You
will find the log in MSSQL\Log folder under the installation path.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
news:eHXmsUcmEHA.3352@.TK2MSFTNGP10.phx.gbl...
> Friends,
> The SQL server 2000 was running fine until all of a Sudden I got this
> message,
> SQL Server is aborting. Fatal exception c0000005 caught.
> The Service would not start, and I need help in Recovering it.
> Any help is greatly Appreciated.
> --
> Santosh
>|||Hi Vyas,
Sorry for the late reply,
The error log just says the below and halts at the last step.
2004-09-13 17:09:54.39 spid11 Starting up database 'jennifertest'.
2004-09-13 17:10:02.75 spid3 Recovery complete.
2004-09-13 17:10:02.75 spid3 SQL global counter collection task is
created.
Do you want any other file like SQLDump?
TIA
--
Santosh
Can you check the SQL Server error log and post the error messages here? You
will find the log in MSSQL\Log folder under the installation path.
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Santosh" <santoshNoSpam@.NoSpam.net> wrote in message
news:eHXmsUcmEHA.3352@.TK2MSFTNGP10.phx.gbl...
> Friends,
> The SQL server 2000 was running fine until all of a Sudden I got this
> message,
> SQL Server is aborting. Fatal exception c0000005 caught.
> The Service would not start, and I need help in Recovering it.
> Any help is greatly Appreciated.
> --
> Santosh
>

Help - Recovering a deleted job

Any ideas how I can recover a job that has been deleted (?) from SQL
7.0 ? We had one which was used on a regular basis which has now
ceased to exists. I've spoken to the people responsible for the server
and was met by blank faces (as usual). They have no idea when it was
deleted, by whom or when. To make matters worse, they don't think they
can get it off the backup set without a major bit of work to the
server. Suprisingly, none of the users noticed that things had stopped
working.

Unfortunately, I needed to do some work on this in preparation for my
monthly meeting with my boss on Monday. Whilst I'm not to blame, I'd
like to understand a little more about any options available to us for
recovery as he will undoubtedly ask when he finds out.

I have an old back up on another server, so it's not the end of the
world re-creating it, but I was under the impression it was backed up
properly. Is this normal or have they missed something ?

Are there any ways I can recover this ? What can I get done to the
backup to make sure this is backed up properly ?

Thanks in advance.

Ryan> Are there any ways I can recover this ? What can I get done to the
> backup to make sure this is backed up properly ?
> Thanks in advance.
> Ryan

If you ahve a maintenance plan that covers the system databases then you
should have a copy of the msdb database somewhere - this is the one that you
want.

Using Enterprise manager, restore this backup onto the same server, but
under a database name of "OLDmsdb"

From here, you shoul dbe able to explore sysjobs and sysjobsteps.

It is POSSIBLE to move these entries into the relevant system tables on the
live msdb, but my recommendation would be to extract the data you need from
the old sysjobsteps table, then re-create the new job manually.

Steven