Tag Info

Hot answers tagged

6

I'm guessing here based on how I'd implement MIRROR TO: Probably, SQL Server streams the backup data to two backup devices if you use MIRROR TO. This means that every block they read is written two times. The data stream has a fork. What they are certainly not doing is write the data once and then copy it over. That would a) incur an additional read pass ...


2

The index data order on disk for text columns depends on the locales provided by the underlying operating system. The same locales (that is, with the same name) may differ between operating systems on the order rules, even on simple things. As an example this question: PostgreSQL 9.1 streaming replication problem: replica fails to use an index properly ...


1

You are going to find this shocking, but you only need one major option : --opt What is --opt ? This option, enabled by default, is shorthand for the combination of --add-drop-table --add-locks --create-options --disable-keys --extended-insert --lock-tables --quick --set-charset. It gives a fast dump operation and produces a dump file that can be ...


1

If the database is down when the backup is supposed to start the backup can not run. If the database goes offline while the backup is running the backup will simply stop. It'll need to be restarted after the database comes back online. There won't be anything logged that there was a backup running when the database went offline. You'd need to look at the ...



Only top voted, non community-wiki answers of a minimum length are eligible