A database with simple recovery mode and datafile size 418 GB, backup is really slow. What is the fastest way to backup the database.
A database with simple recovery mode and datafile size 418 GB, backup is really slow. What is the fastest way to backup the database.
The fastest way is a snapshot-based backup. Which is nothing you do from SQL Server, but typically something you do on your SAN. And just because the backup is faster, it does not mean that the restore will be smooth.
What environment is this? If the backup is slow, this is because your storage subsystem is what it is.
@ErlandSommarskog, thank you for quick response. Yes you are right and I am using the process to detach the database and copy datafile and log files and then move it to different location.
12 people are following this question.