question

SahaSaha-5270 avatar image
0 Votes"
SahaSaha-5270 asked SahaSaha-5270 commented

A database with datafile size 418 GB backup is running very slow

A database with simple recovery mode and datafile size 418 GB, backup is really slow. What is the fastest way to backup the database.

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

ErlandSommarskog avatar image
1 Vote"
ErlandSommarskog answered SahaSaha-5270 commented

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.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@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.

0 Votes 0 ·