The Multifunctioning DBA:

Restore

1

July 30, 2010  10:00 PM

SQL Server Test Instances



Posted by: Colin Smith
Restore, SQL Server

Lately I have had a number of test databases where the log file has just gotten way out of control and I have been close to running out of disk space. This is a problem and it is caused by someone, including me, restoring a database from production to the test instance. If the database in...

July 30, 2010  10:00 AM

Backup and Restore



Posted by: Colin Smith
DBA, Recovery, Restore

I am fighting a battle right now of whether or not I, the DBA, or the backup team at my company should be in charge of backups and restores of the SQL Server Databases in the company. We use Netbackup with a SQL Agent to back up the databases and I am still not sure that I am a huge fan of that. I...


February 16, 2010  3:48 PM

What is the Primary Job of a DBA?



Posted by: Colin Smith
backup, Restore, SQL Server Administration

So this post is about DBA's like me. I am a systems DBA and not a developer. In fact I know very little about the language of SQL and I need to learn a lot more about it and hopefully I can integrate using more SQL into my job. Anyway, I ask the question of what is the primary responsibilty of a...


1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: