sql is not up

• ramyours2003

  SSChampion

  Points: 12268

  More actions

  October 5, 2012 at 3:06 am

  #263419

  when we tried to move temp datafiles from one location (d: drive )to another location (f: drive), but the alter cmd failed due to the drive is not present , sql is not coming up .How to bring back the sql again .

• derek.colley

  SSCrazy Eights

  Points: 8040

  More actions

  October 5, 2012 at 3:28 am

  #1545961

  There's probably a way of modifying this value directly in the system databases, but a quick hack-y method would be to create a new LUN (drive letter) at the OS level, F:, and restart SQL Server. Don't forget to create the folder structure you specified, too, and modify the permissions. The tempdb files will then be created in this directory. You can then issue your ALTER statement again to where you really want the tempdb files, restart SQL Server, and remove the LUN.

  ---

  Note to developers:
  CAST(SUBSTRING(CAST(FLOOR(NULLIF(ISNULL(COALESCE(1,NULL),NULL),NULL)) AS CHAR(1)),1,1) AS INT) == 1
  So why complicate your code AND MAKE MY JOB HARDER??!:crazy:

  Want to get the best help? Click here https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help (Jeff Moden)
  My blog: http://uksqldba.blogspot.com
  Visit http://www.DerekColley.co.uk to find out more about me.

• Gazareth

  One Orange Chip

  Points: 27737

  More actions

  October 5, 2012 at 3:50 am

  #1545971

  You could also look into starting sql server in minimal configuration mode (-f switch).

  This may allow you to get to a point where you can reissue the ALTER DATABASE commands for tempdb.

  There's a blog post from Jonathan Kehayias on it here: http://sqlblog.com/blogs/jonathan_kehayias/archive/2009/01/06/error-5123-severity-16-state-1-when-moving-tempdb.aspx