Your DBA is correct, in the sense pages will defrag but will not have much effect. Eg: if you defrag table which has 20000 pages count may reduce the page...

How many instances you have on this box?

Is Login (failing login name) name already set up in AD?

I think it should uninstall only the instance you had selected. If you want to be on safe side take snap shot of the system, Server Team\Windows Team should...

Roy is right. Use same domain account to set up replication to make it easy and simple, if login doesn't match between publishers, distributor and subscriber replication will break, believe...

Did you copy backup file form Prod to Test environment?

We had issues copying back up files from production to Dev environment. There is a way to restore Dev environment...

Audit Login and filter by login name in column filter.

If possible use separate data drive for Temp DB data and log files.

EnjoY!

Make sure you also check all the backup files, they may be corrupted some times. Run full backup of all servers once they are back online.

EnjoY!

I agree with Gail, but diff backup takes almost same time and space as full backup again it depends. Personally i would prefer full back every night and log backup...

Depends on data updates you perform on the table, Best practices is b\w 70 - 80% fill factor.

EnjoY!

SSMS --> Security --> Right click on Login --> from there you can do it.

EnjoY!

It's very easy believe me. You planning to stop SQL Services also?

No need to stop any applications while you are applying SP.

Turn off replication on both servers.

Make sure full back...

George is right, when you install SQL on cluster work station components gets installed only on active node, you have to install work station components on other node if you...

It will just reserve the space, but you should be able to access that space for other applications. The maximum size it can grow is size of the database at...