cphite
SSCarpal Tunnel
Points: 4278
More actions
February 10, 2014 at 9:43 am
#1687599
GilaMonster (2/9/2014)cphite (2/9/2014)The only catch is that if for whatever reason the new location isn't accessible, SQL won't start and you'd need to restore master.SQL won't start in that case, but you don't need to do anything as extreme as restoring master.http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
GilaMonster (2/9/2014)
cphite (2/9/2014)The only catch is that if for whatever reason the new location isn't accessible, SQL won't start and you'd need to restore master.
cphite (2/9/2014)
SQL won't start in that case, but you don't need to do anything as extreme as restoring master.
http://www.simple-talk.com/sql/backup-and-recovery/the-sql-server-instance-that-will-not-start/
Ah, okay - cool... I did not know that would work 🙂
Nadrek
SSC-Insane
Points: 20039
February 10, 2014 at 12:04 pm
#1687653
GilaMonster (1/14/2014)Moving TempDB is easy. The other three, not so much.
GilaMonster (1/14/2014)
MSDB and Model are fairly easy, too.
Master's where you have to pull out the fun startup parameters.
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply