SQL Error Messages / SQL Troubleshooting
by Manzoor Siddiqui · Published June 24, 2015 · Last modified September 24, 2015
324viewsRecently 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...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published June 22, 2015 · Last modified September 24, 2015
1.3kviewsLog 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,...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published June 20, 2015 · Last modified September 24, 2015
955viewsAs 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...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published June 18, 2015 · Last modified September 24, 2015
2.1kviewsIf 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...
Articles / Database Administration / SQL Server / SQL Tips and Tricks / Tutorials
by Manzoor Siddiqui · Published June 14, 2015 · Last modified September 24, 2015
896viewsIn 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...
Articles / SQL Server / SQL Tips and Tricks / SQL Tools / Tutorials
by Manzoor Siddiqui · Published June 11, 2015 · Last modified September 24, 2015
1.1kviewsBulk Copy Program (BCP) is a powerful command line utility to import and export data in SQL Server database. If you do not have much knowledge about database commands then also you can use it...
