Database Restores; Terminates Abnormally

Hi to All!
i have data base restore problem. i have backed up data base with verify
the backup option last w now i have server crash and i have two
recent backups with me. When i restore the latest one it terminates
abnormally. when i restore the other backup it restores okay. what may
be the problem in restoring the latest backup or which optin i shuould
select in the options to restore the data sucessfully.
Thanx
*** Sent via Developersdex http://www.examnotes.net ***Hi Ghulam,
What error do you get when the restore fails ?
"Ghulam Farid" wrote:

> Hi to All!
> i have data base restore problem. i have backed up data base with verify
> the backup option last w now i have server crash and i have two
> recent backups with me. When i restore the latest one it terminates
> abnormally. when i restore the other backup it restores okay. what may
> be the problem in restoring the latest backup or which optin i shuould
> select in the options to restore the data sucessfully.
> Thanx
>
> *** Sent via Developersdex http://www.examnotes.net ***
>

database restore - msdb

Hi, In the event of a system crash, whereby the whole server had to be
re-built, how would I best restore the msdb database, in order to restore
all DTS's which I had?Hi Ben,
Please read the following article and you will find answers
http://support.microsoft.com/default.aspx?scid=kb;en-us;224071
HTH
Andreas
"Ben Rum" wrote:
> Hi, In the event of a system crash, whereby the whole server had to be
> re-built, how would I best restore the msdb database, in order to restore
> all DTS's which I had?
>
>|||Ben:
You can simply restore msdb from a backup that you have made as long as no
one is using it. That really means to just stop the SQL Server Agent
process and restore the database and then start the Agent back up. Works
like a champ (I actually had to do it this weekend due to a server failure).
One issue though is to remember to press your F5 key to refresh your view in
EM or you may end up giving yourself an unnecessary heart attack.
See the following if you want/need it straight from Microsoft:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_bkprst_2w1f.asp
Scott
"Ben Rum" <bundyrum75@.yahoo.com> wrote in message
news:u6NVFYJiFHA.2472@.TK2MSFTNGP15.phx.gbl...
> Hi, In the event of a system crash, whereby the whole server had to be
> re-built, how would I best restore the msdb database, in order to restore
> all DTS's which I had?
>

database restore - msdb

Hi, In the event of a system crash, whereby the whole server had to be
re-built, how would I best restore the msdb database, in order to restore
all DTS's which I had?
Hi Ben,
Please read the following article and you will find answers
http://support.microsoft.com/default...b;en-us;224071
HTH
Andreas
"Ben Rum" wrote:

> Hi, In the event of a system crash, whereby the whole server had to be
> re-built, how would I best restore the msdb database, in order to restore
> all DTS's which I had?
>
>
|||Ben:
You can simply restore msdb from a backup that you have made as long as no
one is using it. That really means to just stop the SQL Server Agent
process and restore the database and then start the Agent back up. Works
like a champ (I actually had to do it this weekend due to a server failure).
One issue though is to remember to press your F5 key to refresh your view in
EM or you may end up giving yourself an unnecessary heart attack.
See the following if you want/need it straight from Microsoft:
http://msdn.microsoft.com/library/de...kprst_2w1f.asp
Scott
"Ben Rum" <bundyrum75@.yahoo.com> wrote in message
news:u6NVFYJiFHA.2472@.TK2MSFTNGP15.phx.gbl...
> Hi, In the event of a system crash, whereby the whole server had to be
> re-built, how would I best restore the msdb database, in order to restore
> all DTS's which I had?
>

database restore - msdb

Hi, In the event of a system crash, whereby the whole server had to be
re-built, how would I best restore the msdb database, in order to restore
all DTS's which I had?Hi Ben,
Please read the following article and you will find answers
http://support.microsoft.com/defaul...kb;en-us;224071
HTH
Andreas
"Ben Rum" wrote:

> Hi, In the event of a system crash, whereby the whole server had to be
> re-built, how would I best restore the msdb database, in order to restore
> all DTS's which I had?
>
>|||Ben:
You can simply restore msdb from a backup that you have made as long as no
one is using it. That really means to just stop the SQL Server Agent
process and restore the database and then start the Agent back up. Works
like a champ (I actually had to do it this weekend due to a server failure).
One issue though is to remember to press your F5 key to refresh your view in
EM or you may end up giving yourself an unnecessary heart attack.
See the following if you want/need it straight from Microsoft:
http://msdn.microsoft.com/library/d... />
t_2w1f.asp
Scott
"Ben Rum" <bundyrum75@.yahoo.com> wrote in message
news:u6NVFYJiFHA.2472@.TK2MSFTNGP15.phx.gbl...
> Hi, In the event of a system crash, whereby the whole server had to be
> re-built, how would I best restore the msdb database, in order to restore
> all DTS's which I had?
>

Database Recovery Issue

We had a hard drive crash on one of our servers. There are no backups of the
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). Any
suggestions would be greatly appreciated.There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.

Database Recovery Issue

We had a hard drive crash on one of our servers. There are no backups of the
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). Any
suggestions would be greatly appreciated.
There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.

Database Recovery Issue

We had a hard drive crash on one of our servers. There are no backups of the
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). An
y
suggestions would be greatly appreciated.There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.

Database recovery

Had a server crash totaly. Rebuilt a new server with
different drive partitions. Reinstalled SQL 7 and then
restored master from backup. SQL will not start because
it is looking for model,msdb, temp in the original
location which no longer exists. Had this problem on 2000
as well. Any suggestions?You can try to start SQL Server with two undocumented trace flags:
Trace Flag 3608 does not recover any database except the master
Trace Flag 3609 start without TempDB.
Start the service with -f (minimal configuration) option as well.
If this works, attach the databases, except tempdb. Try to move tempdb to a
new location as described in the "Expanding a Database" topic in BOL
(mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\cr
eatedb.chm::/cm_8_des_03_71d1.htm). If this works, restart SQL Server.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Franco" <franco.carusi@.sbs.siemens.co.za> wrote in message
news:018401c37cdc$b94d0df0$a001280a@.phx.gbl...
> Had a server crash totaly. Rebuilt a new server with
> different drive partitions. Reinstalled SQL 7 and then
> restored master from backup. SQL will not start because
> it is looking for model,msdb, temp in the original
> location which no longer exists. Had this problem on 2000
> as well. Any suggestions?|||Unfortunately a list of undocumented trace flags does not exist in public,
otherwise they would not be undocumented. What you can do is not to restore
the master db after reinstallation, you can just use the "new" one and
attach other databases. But you would have to recreate all logins, map them
to db users etc. The other solution is to call MS support. I think they have
the list:-)
Have you tried with all three, the -f option and both trace flags mentioned
at the same time? I remember few years ago when I had some problems with
tempdb these options forced SQL Sever to skip recovery for all databases,
not just model.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Franco" <franco.carusi@.sbs.siemens.co.za> wrote in message
news:08d101c37cf0$7f7ed680$a401280a@.phx.gbl...
> Tried it and does not work - from the error log it seems
> as if it skipped the model database but is still looking
> for msdb and temp. (previously looking for msdb and
> model). Definately looks as if a step closer. Do you know
> where I can get a list of trace flags?
> >--Original Message--
> >You can try to start SQL Server with two undocumented
> trace flags:
> >Trace Flag 3608 does not recover any database except the
> master
> >Trace Flag 3609 start without TempDB.
> >Start the service with -f (minimal configuration) option
> as well.
> >If this works, attach the databases, except tempdb. Try
> to move tempdb to a
> >new location as described in the "Expanding a Database"
> topic in BOL
> >(mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%
> 20Server\80\Tools\Books\cr
> >eatedb.chm::/cm_8_des_03_71d1.htm). If this works,
> restart SQL Server.
> >
> >--
> >Dejan Sarka, SQL Server MVP
> >FAQ from Neil & others at: http://www.sqlserverfaq.com
> >Please reply only to the newsgroups.
> >PASS - the definitive, global community
> >for SQL Server professionals - http://www.sqlpass.org
> >
> >"Franco" <franco.carusi@.sbs.siemens.co.za> wrote in
> message
> >news:018401c37cdc$b94d0df0$a001280a@.phx.gbl...
> >> Had a server crash totaly. Rebuilt a new server with
> >> different drive partitions. Reinstalled SQL 7 and then
> >> restored master from backup. SQL will not start because
> >> it is looking for model,msdb, temp in the original
> >> location which no longer exists. Had this problem on
> 2000
> >> as well. Any suggestions?
> >
> >
> >.
> >