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?
> >
> >
> >.
> >