Recovery of Database 'xxx' (Complete in 68,395 more seconds)

I'm having a problem with a SQL Server. Every time I stop and restart the
SQL Server service I get a message similar to this one. What do I have to
do to force checkpoints during the load process? ThanksP.S. - The message is coming up in the Application Event Log during the
recovery process after I start the server. I found a quote on the MS
Website stating I "may need to 'Troubleshoot the Recovery Process'", but I
can't find anything more specific than that. Can someone point me in the
right direction? Thanks
"Michael C#" <xyz@.yomomma.com> wrote in message
news:%23G$j92yKFHA.2284@.TK2MSFTNGP10.phx.gbl...
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>|||How is the data being loaded?
--
Simon Worth
Michael C# wrote:
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>|||On this particular box they're using Bulk Insert.
"Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...
> How is the data being loaded?
> --
> Simon Worth
> Michael C# wrote:
>> I'm having a problem with a SQL Server. Every time I stop and restart
>> the SQL Server service I get a message similar to this one. What do I
>> have to do to force checkpoints during the load process? Thanks|||What is the relation between the load and stopping SQL Server? Also, have you change the recovery
interval setting with sp_configure?
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Michael C#" <xyz@.yomomma.com> wrote in message news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl...
> On this particular box they're using Bulk Insert.
> "Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
> news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...
>> How is the data being loaded?
>> --
>> Simon Worth
>> Michael C# wrote:
>> I'm having a problem with a SQL Server. Every time I stop and restart the SQL Server service I
>> get a message similar to this one. What do I have to do to force checkpoints during the load
>> process? Thanks
>|||Today was the first time we've stopped this SQL Server since we started
loading it. The load was completed. No, I haven't changed the recovery
interval; I'll take a look at it today. What setting would you recommend?
Thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23IUlVr4KFHA.4032@.TK2MSFTNGP14.phx.gbl...
> What is the relation between the load and stopping SQL Server? Also, have
> you change the recovery interval setting with sp_configure?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Michael C#" <xyz@.yomomma.com> wrote in message
> news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl...
>> On this particular box they're using Bulk Insert.
>> "Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
>> news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...
>> How is the data being loaded?
>> --
>> Simon Worth
>> Michael C# wrote:
>> I'm having a problem with a SQL Server. Every time I stop and restart
>> the SQL Server service I get a message similar to this one. What do I
>> have to do to force checkpoints during the load process? Thanks
>>
>

Recovery of Database 'xxx' (Complete in 68,395 more seconds)

I'm having a problem with a SQL Server. Every time I stop and restart the
SQL Server service I get a message similar to this one. What do I have to
do to force checkpoints during the load process? Thanks
P.S. - The message is coming up in the Application Event Log during the
recovery process after I start the server. I found a quote on the MS
Website stating I "may need to 'Troubleshoot the Recovery Process'", but I
can't find anything more specific than that. Can someone point me in the
right direction? Thanks
"Michael C#" <xyz@.yomomma.com> wrote in message
news:%23G$j92yKFHA.2284@.TK2MSFTNGP10.phx.gbl...
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>
|||How is the data being loaded?
Simon Worth
Michael C# wrote:
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>
|||On this particular box they're using Bulk Insert.
"Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> How is the data being loaded?
> --
> Simon Worth
> Michael C# wrote:
|||What is the relation between the load and stopping SQL Server? Also, have you change the recovery
interval setting with sp_configure?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Michael C#" <xyz@.yomomma.com> wrote in message news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl...
> On this particular box they're using Bulk Insert.
> "Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
> news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...
>
|||Today was the first time we've stopped this SQL Server since we started
loading it. The load was completed. No, I haven't changed the recovery
interval; I'll take a look at it today. What setting would you recommend?
Thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23IUlVr4KFHA.4032@.TK2MSFTNGP14.phx.gbl...
> What is the relation between the load and stopping SQL Server? Also, have
> you change the recovery interval setting with sp_configure?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Michael C#" <xyz@.yomomma.com> wrote in message
> news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl...
>
sql

Recovery of Database 'xxx' (Complete in 68,395 more seconds)

I'm having a problem with a SQL Server. Every time I stop and restart the
SQL Server service I get a message similar to this one. What do I have to
do to force checkpoints during the load process? ThanksP.S. - The message is coming up in the Application Event Log during the
recovery process after I start the server. I found a quote on the MS
Website stating I "may need to 'Troubleshoot the Recovery Process'", but I
can't find anything more specific than that. Can someone point me in the
right direction? Thanks
"Michael C#" <xyz@.yomomma.com> wrote in message
news:%23G$j92yKFHA.2284@.TK2MSFTNGP10.phx.gbl...
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>|||How is the data being loaded?
Simon Worth
Michael C# wrote:
> I'm having a problem with a SQL Server. Every time I stop and restart the
> SQL Server service I get a message similar to this one. What do I have to
> do to force checkpoints during the load process? Thanks
>|||On this particular box they're using Bulk Insert.
"Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...[vbcol=seagreen]
> How is the data being loaded?
> --
> Simon Worth
> Michael C# wrote:|||What is the relation between the load and stopping SQL Server? Also, have yo
u change the recovery
interval setting with sp_configure?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Michael C#" <xyz@.yomomma.com> wrote in message news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl..
.
> On this particular box they're using Bulk Insert.
> "Simon Worth" <REMOVEFIRST_simon.worth@.gmail.com> wrote in message
> news:%23e3nP%23yKFHA.1284@.TK2MSFTNGP14.phx.gbl...
>|||Today was the first time we've stopped this SQL Server since we started
loading it. The load was completed. No, I haven't changed the recovery
interval; I'll take a look at it today. What setting would you recommend?
Thanks
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:%23IUlVr4KFHA.4032@.TK2MSFTNGP14.phx.gbl...
> What is the relation between the load and stopping SQL Server? Also, have
> you change the recovery interval setting with sp_configure?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Michael C#" <xyz@.yomomma.com> wrote in message
> news:ON8LT$yKFHA.1600@.TK2MSFTNGP10.phx.gbl...
>

Recovering dropped SQL database

I am in a big trouble ,

accidently i have issued a DROP DATABASE XXX command in the sql client, thinking its a local server....... The whole 4 months of database database is now dropped.

Please help me , how can i recover the database ....

thanks in advance

If you don′t have a backup of the data, I will have to tell you, that there is no UNDO button for that. Sorry.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.desql

Recover db

If i only have xxx backup file and xxx.sql file, can i recover the database from this 2 file? Please helpQ1 If i only have xxx backup file and xxx.sql file, can i recover the database from this 2 file?

A1 More details would help understand your question more clearly. A full DB backup dump allows restoration of a DB including data, approximatly to the state of that DB at the time of the backup dump. A .sql file is more likely a script (probably containing object creation tsql, etc.) that would create the DB structures (but probably was not written /created to insert all the DB data).