Restoring default databases?

W

WSGlebKavash2021-09-14 15:27:27

SQL Server

WSGlebKavash, 2021-09-14 15:27:27

Copied databases from one server to another and the MSSQLSERVER service stopped starting. As it turned out, if the standard databases are changed, the server stops working. Standard databases:

master.mdf
msdbdata.mdf
Tempdb.mdf
model.mdf

How to restore default databases? How to transfer databases from one server to another?
DBMS: Ms SQL

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

K

Konstantin Tsvetkov, 2021-09-14
@tsklab

Migration Documentation .

How to transfer databases from one server to another?

Custom - the easiest way is to detach, copy the mdf file and attach it on a new server, keeping in mind that MS SQL is not backward compatible. Documentation .