_覓 | 覦覈襦 | 豕蠏手 | 殊螳 | 譯殊碁
FrontPage › MasterDatabaseRestore
Data Analysis(R)
Data Analysis(Python)
Statistics
Data Warehouse
Database System
SQL Server
Trino
Hive
Hadoop
Regular Expressions
Tools
Money
Working Smart
Blog
Booklog
Philosophy
Link
Miscellaneous
__ edit





[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. 觜 ろ
鏤
蠍 蠍郁鍵..
企: : るジ讓曙 襦螻豺 企Ν 譯殊語. 襦螻豺
EditText : Print : Mobile : FindPage : DeletePage : LikePages : Powered by MoniWiki : Last modified 2018-04-13 23:12:52

螻企 覈詩 企Μ 豺 手幻 襷 る 語 螳 覲牛 企. ( 覩碁 覲企 螻襦 殊 蟶狩襷 讌願 襴ろ)