_ | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › MasterDatabaseRestore

覲旧 谿 #

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

master 覲旧 servername 覦覯 #


select @@servername
--> old_name

select SERVERPROPERTY ('servername' )
--> new_name

  1. sp_dropserver 'old_name'
  2. sp_addserver 'new_name',local
  3. 觜 ろ
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:52

谿蟆 磯る 蟆 伎襭 苦 讌 讌襦蟆 磯る 蟆 願鍵 苦 螳 讌 螳 覺 .