Answer the question
In order to leave comments, you need to log in
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
Answer the question
In order to leave comments, you need to log in
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 questionAsk a Question
731 491 924 answers to any question