SQLServerLog.com - Database Tips, Techniques and Tutorials
490viewsSQL Server replication is a process and technique where data is frequently copied from one database server to another database server. The output or work is distributed across database where relevant data is accessed...
Recently I had configured transactional replication and later I wanted to disable the publishing and distribution settings but I was getting Microsoft SQL Server Error: 15517 which states that SQL Server could not disable publishing...
Log shipping is a low cost technique for disaster recovery solution which you can setup on primary server database and one or more secondary server databases. This is basically a three step process backup,...
As a part of SQL Server migration we need to migrate all the logins and passwords from one SQL Server instance to other SQL Server instance or you can also transfer specific login and...
514viewsIf you want to protect your valuable data from unauthorised access you normally use some technique like password protection or by key protection etc. Encryption is the process of protecting data with key or...
In previous article we have seen database backups and types, so in continuation to that we are going to discuss about how to restore database on same instance or different instance. We have already taken...