Tags » Dba

SQL Mirroring, Preserving the Log Chain During Database Migrations

Database mirroring has been deprecated since SQL Server version 2012 and now with the advent of SQL 2016 SP1 which happens to include two node Always On in Standard edition, surely there’s no place in the World for it, right? 1,274 more words

SQL Server

What is log shipping ?

What is log shipping?

  • Log shipping is one of the high availability technique in SQL Server.

                              Log shipping is the process of automating the backup of a database and transaction… 25 more words

SQL DBA

Fix: Error: 15138 – The database principal owns a schema in the database, and cannot be dropped

Fix: Error: 15138 – The database principal owns a schema in the database, and cannot be dropped

Recently I was dropping orphan user from database SSISTEST and Got below error: 165 more words

DBA

Fix Error: Could not drop login ‘test’ as the user is Currently logged in( Microsoft SQL Server , Error:15434)

Fix Error: Could not drop login ‘test’ as the user is Currently logged in( Microsoft SQL Server , Error:15434)

 Recently I have created a test… 120 more words

DBA

Council Agenda Preview - January 17, 2017

Fill Out This Form with Your Name and Contact Information to Win Big. No Purchase Required.

This seems to the essence of Item 9.1.1 – Waterfront Casino and Hotel Conference Centre. 1,251 more words

Parry Sound

Task- Bulk Insertion

Bulk insertion is used to transfer data from files to SQL server tables.

In this article, I provide an overview of bulk insertion task of SSIS. 322 more words

DBA

Noorwegen schakelt FM uit voor DBA

Als eerste schakelt Noorwegen de FM uit om plaats te maken voor de digitale radio. Of het daar klaar voor is is de grote vraag. Lang niet iedereen heeft een digitale radio in huis, laat staan in de auto. 235 more words

Ergernissen