How to backup SQL Server database files directly?

Question

My Windows 10 installation is corrupted and I can't login anymore. I'm using Ubuntu Live to copy all the files to an external HDD. Is there a way i can copy the database files directly then restore them after i install Windows and SQL server again?

Stop SQL Server and copy mdf and ldf files.

Max
– Max

2017-04-16 11:01:45 +00:00
Commented Apr 16, 2017 at 11:01 — Max
– Max, Commented Apr 16, 2017 at 11:01

Alex · Accepted Answer · 2017-04-17 16:03:49Z

1

Use restore files and filegroups instead of restore the database. If all files (.bak/.ldf/.mdf) are valid it should work fine

answered Apr 17, 2017 at 16:03

Alex

2631 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to backup SQL Server database files directly?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related