W
W
WSGlebKavash2021-09-14 15:27:27
SQL Server
WSGlebKavash, 2021-09-14 15:27:27

Restoring default databases?

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

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 .

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question