similar issues, I had SQLVDI from CommVault is holding a read lock on all the databases, Killed/Suspended the job in CommVault, restarted the server in the middle of the night,...

good article about tranisition into what you want to become. I have been working on SQL server database administration for the last twelve years. I am pursuing to change my...

good article about tranisition into what you want to become. I have been working on SQL server database administration for the last twelve years. I am pursuing to...

Same aggregate with different logical volumes at Windows, would not prove any performance gain. Per statement, I am presuming that 16 filegroups are going to 16 disks (again same...

Our organization is in development. So a development lead/mgr dictates production operations, basically just drop anything that a production DBA handles, give what the dev lead says, bending backwards.

Hmmm,...

If the developers have fixed role "Sysadmin" on development machines, they will be able to view Standard reports, as you know. If any production restores happen on development machines,...

Can be done at Active Directory Domain Trust. Both domains need have trust and and an exception with IP address. Please look for the article called:

"Create a two-way,...

My bad.

I agree with Scott Coleman in what was covered. I can performn Windows administration as well. So that means, job functions would overlap.

Our company is also small. ...

Downtime:

- What happend to log shipped database which can be used to repair with data loss.

- What happend to differential backups which can be restored somewhere and repair.

Look, unexpected failures...

I apologize for late entrance.

The way MS operates, they release patches without DBA's intervention, how cool is that. NO, why? You have some background processes that run in...

Different options:

Option 1

disable publishing then drop the distributor.

ref: http://msdn.microsoft.com/en-us/library/ms147921.aspx

Option 2

running xp_repldone with appropriate parameters:

Larry G's SQL syntax to run wherever distribution db is:

-- first tell repl it can...

You are going to truncate production database log in order to drop distribution database???

This article was in pending for several months and posted now on how I have performed/achieved in backup and restore of a 200 GB production db to a FAT32.

Thoughts and...

I missed a step in including that is, restoring the database to a server where there is enough space and test this hypothesis, execute WITH TRUNCATE_ONLY

and the remaining steps to...