Browse the archive

Server Fault

Can I use both Log Shipping and Transaction Replication at the same time?

October 15, 20211 min read

Rich Vieira asks about the feature compatibility of using AlwaysOn Availability Groups and Replication on the same database.

Databases

SQL Server Page File location - where to put it?

October 31, 20194 min read

Tobias asks if it matters where Windows places its page file on a SQL Server server.

Databases

Why can't I restore encrypted backup through front end?

October 30, 20193 min read

UserSteve is having trouble restoring an encrypted database backup to a new server. I try to walk him though the steps of getting the necessary encryption keys on the destination server.

Databases

Copying SQL Server settings to new server

October 17, 20192 min read

UserSteve is upgrading to a new server and needs to move all his server settings to the new instance. I introduce him to DBA Tools as a quick way to copy configurations and other stuff to the new instance.