[edit]

覲旧 谿 #

  1. 覈襦 (sqlservr.exe -m)
  2. sqlcmd
  3. restore database master from disk='c:\master.bak' with replace, recovery
  4. service restart

[edit]

master 覲旧 servername 覦覯 #


select @@servername
--> old_name

select SERVERPROPERTY ('servername' )
--> new_name

  1. sp_dropserver 'old_name'
  2. sp_addserver 'new_name',local
  3. 觜 ろ