Browse the archive

Server Fault

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

October 15, 20211 min read

Question Good Morning, I have a SQL Server 2016 that is doing Log Shipping to a DR Site. I currently want to also to Replicate (Transactional) specific Tables to another Server for Reporting Purposes. Will there be any issues or snafu’s I should be aware of? …

Databases

SQL Server Page File location - where to put it?

October 31, 20194 min read

Question There are a lot of recommendations about the sizing of the windows page file. What I am looking for is the correct placement. We are running a MS SQL server on a Server 2012R2 VM with multiple seperate virtual disks:

Databases

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

October 30, 20193 min read

Question I’m just starting to experiment with encrypting backups, I think I now understand it and have got the process working, but something strange is happening with restoring. On Server A (SQL 2014 Standard) I have created a new master key and certificate …

Databases

Copying SQL Server settings to new server

October 17, 20192 min read

Question We are a small business using a single SQL Server 2014 instance as our main data platform. We now need to set up a second instance (2017) to hold additional data - this is to be standalone, ie not replicated or actively linked to the main server.