restore "master" from different Sever

• Randy Justice

  Old Hand

  Points: 315

  More actions

  May 11, 2004 at 1:11 pm

  #108245

  Hi

  Everyone has been so much help to me... Thanks....

  I have restored a "master" DB from a difffernent server.  I can not connect to my instance.

  I have checked the log file and I get the following error..

  spid5     udopen: Operating system error 3(The system cannot find the path specified.) during the creation/opening of physical device S:\Program Files\Microsoft SQL Server\MSSQL\data\model.mdf.

  FCB:pen failed: Could not open device S:\Program Files\Microsoft SQL Server\MSSQL\data\model.mdf for virtual device number (VDN) 1.

  spid4     Server name is 'PENS2315'.

  spid5     Device activation error. The physical file name 'S:\Program Files\Microsoft SQL Server\MSSQL\data\model.mdf' may be incorrect.

  spid5     Device activation error. The physical file name 'S:\Program Files\Microsoft SQL Server\MSSQL\data\modellog.ldf' may be incorrect.

  spid5     Database 'model' cannot be opened due to inaccessible files or insufficient memory or disk space.  See the SQL Server errorlog for details.Starting up database 'msdb'.

  Can my system start without a "model" DB?  How do I change to point to the correct drive..  The model DB exists on the "D" drive...

  Can someone provide me some direction?   

   

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  May 11, 2004 at 1:20 pm

  #506035

  You will need to start SQL with the Trace flag of T3608, this will only recover the master database and so will allow you to change the location of model. See http://support.microsoft.com/default.aspx?scid=kb;en-us;224071&sd=tech for more information.

  ---

  
  Shamless self promotion - read my blog http://sirsql.net

• Randy Justice

  Old Hand

  Points: 315

  More actions

  May 12, 2004 at 9:46 am

  #506170

  Ok...

  I start the system with -m and -T3608.   I'm able to restore master file from the other server.    I logon Query Analyzer and execute

  sp_detach_db 'model'

  sp_attach_db 'model','D:\SQLDATA\MSSQL\Data\model.mdf','D:\SQLDATA\MSSQL\Data\modellog.ldf'

  I can't get back to startup parameters to remove -M.   Can I remove the startup parameters without using the EM?

   

   

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  May 12, 2004 at 10:53 am

  #506178

  Why can't you connect using EM?

  You could alternatively remove paramters directly from the registry by deleting the relevant keys under

  HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\MSSQLSERVER\MSSQLSERVER\PARAMETERS

  ---

  
  Shamless self promotion - read my blog http://sirsql.net

• Randy Justice

  Old Hand

  Points: 315

  More actions

  May 12, 2004 at 12:12 pm

  #506187

  Thanks for your help...

  I got it done.. It was a mess....

  The tempdb DB was in the wrong place...  I used the -f parameter and started the system.   I used the following command to move the tempdb...

  Alter database tempdb modify file (name = tempdev, filename = 'D:\SQLDATA\MSSQL\Data\tempdb.mdf')

  Alter database tempdb modify file (name = templog, filename = 'D:\SQLDATA\MSSQL\Data\templog.ldf')

  I had a lot of small things...  Thanks for your help...