Category Archives: Disaster Recovery
The most recent backup problem
When I first began this blog, back at the beginning of my DBA career, it was purely a place for me to keep queries, things I was learning, processes and handy links. This is one of those posts, there’s nothing new or ground-breaking … Continue reading
Another great reason to enable remote admin connections
I recently came cross another great reason to enable the remote admin connections server configuration on SQL server. If you don’t know what the DAC is I’m not going to go into detail here so check out these posts here, … Continue reading
Restores in SQL Server Analysis Services
“You’re only as good as your last restore” I’ve no idea who originally said that – but it probably qualifies as DBA folklore. I blogged recently about backups in SSAS so to close the loop here are the basics of … Continue reading
Backups in SQL Server Analysis Services
Analysis Services databases should be backed up at regular intervals like any other database. Here are the basics. Using the GUI: Connect to the SSAS service in SQL Server management studio. Right click on the database and select backup. The … Continue reading
Corrupt Model database
An interesting case arose at work the other day. SAN issues had caused SQL Server to shutdown and it was unable to be restarted because the data files were unavailable. Once the SAN was back online the instance still could … Continue reading
Locked out of SQL Server.
This is a very cool and useful tip if you find yourself locked out of the sysadmin role in sql server. I have a SQL Server instance with the sa account disabled and all other logins removed to simulate a … Continue reading