-
Continue reading →: RESTORE DATABASE is terminating abnormally.Msg 905, Level 21, State 1, Line 1.
Recently one of my friends(Rookie DBA, Just started his career as a Jr DBA) called me and mentioned about this error he encountered while he was trying to restore a database(2008) from prod to Non-Prod Environment and was wondering how to make it work. “RESTORE DATABASE is terminating abnormally.Msg 905,…
-
Continue reading →: The Network folder specified is currently mapped using a different user name and password
Today I was trying to map a network drive on my laptop and received a message saying “The Network folder specified is currently mapped using a different user name and password“. Well, I thought there is one and went into “My Computer”. interestingly….I don’t see it! Well, I rebooted the…
-
Continue reading →: SIMPLE Recovery Model Database waiting on LOG BACKUP!!!!
Recently I’ve encountered a strange issue with one of our databases. This is a SQL Server 2012 Instance(SP1). This is our staging environment and was hosting many databases(Few in SIMPLE and few in FULL Recovery Model). Note: The Recovery Model for “MODEL” database on this Instance was “SIMPLE”. We kept this…
-
Continue reading →: Installing SQL Server 2014 CTP1 – My experiences!
Hey Folks….Let me share my experiences with Installing SQL Server 2014 CTP1 which got released couple of weeks ago. It was pretty straightforward if you are already aware of Installing SQL Server 2008-2012(With few GOTCHAS). I tried Installing on Windows Server 2008R2 and I got the below shown message. So…now…
-
Continue reading →: SQL Server 2012 SP1 CU5 and 2008 SP3 CU12 got released
Microsoft released CU5 for SQL Server 2012 SP1 and CU12 for SQL Server 2008 SP3 yesterday. You should be running on 2012 SP1 to be able to Install CU5 and on 2008SP3 to install CU12 respectively. Get 2012 SP1 CU5 here and 2008 SP3 CU12 here.
Howdy!
Welcome to MSSQLTREK, my little corner of the internet where I geek out about SQL Server, databases, and all things cloud. This blog is my space to share lessons learned, cool tips, real-world troubleshooting stories, and the occasional deep dive into data and performance. Whether you’re a fellow Cloud Architect, DBA, Developer, or just cloud-curious, come along for the ride — let’s explore, optimize, and build awesome data solutions together!
Recent posts
Let’s connect
Join the party!
Stay updated with my posts…
- AlwaysOn
- AlwaysOn Availability Groups
- Announcements
- Backups and Restores
- Cloud Computing
- Clustering
- Configuration
- Containers
- Corruptions
- Database
- Database Options
- DB Snapshots
- DBA Tips/Tricks
- DBCC.
- Disaster Recovery
- Encryption
- Generic Errors
- GraphDB
- HADR
- linked server
- Linux/RHEL/CentOS
- Maintenance Plans
- Microsoft Azure
- Mirroring
- miscellaneous
- MongoDB
- MSDTC
- Neo4J
- PerfMon
- Polls
- Service Packs/Cumulative Updates
- SQL Azure
- SQL Denali CTP3
- SQL In Linux
- SQL Server 2008/20008R2
- SQL Server 2012
- SQL Server 2014
- SQL Server 2014 CTP1
- SQL Server 2016
- SQL Server 2017
- SQL Server 2019
- SQL Server Client tools
- SSAS
- SSIS
- SSMS
- SSRS
- Tools
- Trace Flags
- Uncategorized
- Windows
- Windows Server
- Windows Server 2012
