I hope you have used the maintenance plan to backup the files in the database. If thats the case you have the option to remove unused space in database in...

between servers - what is the account under which your sql server service runs. If local system then you will find this problem you will need to run under a doamin...

These links will be really useful for you.

http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en 

SQL Server 2005 upgrade manual. (This document can be used as a guide to proceed...

One thing that i can think of as of now is to use the xp_regwrite procedure to write a batchfile to execute against all servers. Anyways all your services will...

You can install client components and use them to deploy or execute the SSIS package.

When you say that you do a transactional backup every 3 hours i assume that the database is somewhat critical and is a OLTP database. Remember that when a database...

Data will be moved with th index only when its clustered else the data pages and index pages will remain separated.

You can add the permissions and privileges given to the database server and objects. Add the level of user rights in the servers. Access to file and folder paths. How...

I hope you should have placed the data files and log files under a NTFS volume. give privilege to the users only who need to read/write the database. for others...

Do all your 1200 servers run with SQL Server. If not you have to find a way with vb script to change the properties of the service to disabled. Also...

Are you sure that the path that you have given for the transaction log backup file is correct and the network path for copying is also right. Are you using...

Jeff, I am speaking about the one posted by Charlie.

Brandie,

Check if SPN is set correctly for this computer.

You can verify the the integrity of the database backup once the backup is complete. This can be done with choosing verify the intgrity of backup after completion if done...

This script that i have posted here is a non cursor script from the user side. But intern it calls a server side cursor but it executes faster than your...