Browse the archive
Question I have SQL server 2017. I have one 3 TB size database there. Somehow due to long running transaction the database got stuck 'IN Recovery' mode after SQL server Restarted. When I checked the sql error logs it says 2 189 255 seconds remaining (Phase 2 …
Continue readingQuestion We're working on migrating some SQL Server VMs to Azure SQL Managed Instances. We did an initial backup/restore without a problem: RESTORE DATABASE [xxx] FROM URL = 'https://<account-name>.blob.core.windows.net/<container-name>/<filename>.bak' After …
Continue readingQuestion I have system where my database gets restored every night, and off late the restore is taking a lot longer from past few days. Here is server config: ES 2637 XEON @ 3.5 Ghz Windows virtual server 2012 R2 hosted in a Hyper V environment RAM: 128 GB 8 …
Continue readingQuestion I am using SQL Server Express edition, so there is no features for backup plan, I want to take databases backup using bat script, and create a scheduler to be run everyday. I have created .bat file but need to place a time stamp at the end of backup …
Continue readingOver on Stack Exchange, someone asked why their transaction log was growing very fast during a full backup. An interesting tidbit to this question is that the database is in SIMPLE recovery – so the log should stay tiny, right? Wrong. While taking a full …
Continue readingQuestion This question was attempted twice on experts-exchange with no real answer. I know that I should not shrink the log file - that is not the question. If you feel like answering that one should not do it- that has been confirmed many times yes and it is …
Continue readingQuestion I create a bacpac from azure and restore to my local on-prem server. However, it throws an error like “Please create a master key in the database or open the master key in the session before performing this operation”. The reason is one of the column …
Continue readingIt’s T-SQL Tuesday, the blog party that SQL Server expert Adam Machanic (blog|twitter) started. This month’s episode is hosted by Kenneth Fisher (blog| twitter). The topic: Backup & Recovery ## Your backups are my bread & butter Backup & recovery are a DBA's …
Continue readingQuestion I cannot restore a Microsoft SQL Server database due to lack of hard drive space. The original database was 1.6TB and approximately 1.4TB was deleted from it and a backup was taken without shrinking the database. The backup file is only 168GB and was …
Continue readingQuestion Imagine we have two nodes participating in SQL 2012 AO. This is a test instance. During one of the index rebuild operation the log was grown up really big (250 GB). We are unable to back it up due to space constraint. What if we backup the Tlog to …
Continue reading
