Profile cover photo
Profile photo
Ashok Kumar
62 followers
62 followers
About
Ashok's posts

Post has attachment
New File growth effect Primary MDF and Secondary NDF Added in SQL Server
New File growth effect Primary MDF and Secondary NDF Added in SQL Server s p_h e l p db db info initially it was only 6 MB Added some sample records to table on test db growth table after added records you can see growth only on M D F file only Now we added...

Post has attachment
New File growth effect Primary MDF and Secondary NDF Added in SQL Server
New File growth effect Primary MDF and Secondary NDF Added in SQL Server sp_helpdb db info initially it was only 6 MB Added some sample records to table on testdbgrowth table after added records you can see growth only on MDF file only Now we added secondar...

Post has attachment
How to MOVE database MDF and LDF file to New Drive location
--take datafile path --change filepath through query --copy physical file from source location to new location --take offline for DB --take online if we any data file or log file not place correctly we could see following error if db was in recovery pending...

Post has attachment
Local admin access users can not access S S M S (SQL Server Management Studio)
Local admin access users can not access S S M S (SQL Server Management Studio)  when a user is
having local admin access he can’t able to log in to  S S M S (SQL Server Management Studio) . It will give log in
error If user needs to get access to  S S M S (...

Post has attachment
Database Mirroring Real time Examples
Database Mirroring Real time Examples We can't able to restore if Database is different in both source and destination Real time examples: 1)DB different in both Principal and Mirror: Source: Source db: Test D M 02 Destination: Destination db: Test D M 01 b...

Post has attachment
Database Mirroring of Failover and synchronous & asynchronous concepts
Database Mirroring of Fail over and synchronous & asynchronous concepts Fail over : Here  you can see below two database Chinook db mirror test (mirror) and DB Mirror (Principal) when right click database of mirroring and choose task and choose database mir...

Post has attachment
Enabling Semantic Full text index Search existing already installed SQL Server 2012
Statistical Semantic Search uses the indexes that are created by Full-Text Search, and creates additional indexes. As a result of this dependency on full-text search, you create a new semantic index when you define a new full-text index, or when you alter a...

Post has attachment
What is Reverse Log Shipping? How to Swipe/failover Roles of Primary and Secondary in Log shipping Explanation? Step by Step Reverse Log shipping
What is Reverse Log Shipping? How to Swipe/fail over Roles of Primary and Secondary in Log shipping Explanation? Step by Step Reverse Log shipping Video demo of reverse log shipping We should follow below 7 steps to reverse/swipe/fail over log shipping 1.Di...

Post has attachment
What is Reverse Log Shipping? How to Swipe/failover Roles of Primary and Secondary in Log shipping Explanation? Step by Step Reverse Log shipping
What is Reverse Log Shipping? How to Swipe/fail over Roles of Primary and Secondary in Log shipping Explanation? Step by Step Reverse Log shipping Video demo of reverse log shipping We should follow below 7 steps to reverse/swipe/fail over log shipping 1.Di...

Post has attachment
What is Reverse Log Shipping? How to Swipe/failover Roles of Primary and Secondary in Log shipping Explanation? Step by Step Reverse Log shipping
What is Reverse Log Shipping? How to Swipe/fail over Roles of Primary and Secondary in Log shipping Explanation? Step by Step Reverse Log shipping We should follow below 7 steps to reverse/swipe/fail over log shipping 1.Disable the log shipping backup job o...
Wait while more posts are being loaded