To find out whether or not the data file is growing (autogrowths) you can use the Disk Usage report. Right-click on the database, go to reports and select the...

For a good DR strategy, it has to be either tape or some other media that can be taken offline and shipped to offsite storage. Tape is generally easier...

This is not a problem with the databases - it is a problem with backing up across the network. If there are any issues with the network during the backup,...

For those settings, I use a fixed size and not a percentage. What I try to do is pick a size that will allow for several weeks/months of activity....

First, you should be working in a development/test environment and testing your queries before ever getting them even close to a production system.

Next, you can wrap the process in a...

When you attach the database to SQL Server 2005, the database engine upgrades the files. If it did not perform this upgrade - the engine would not be able...

Okay - that is good. Glad we could help.

Lookup SHRINKFILE in Books Online, but here is how you would do it:

Use ReportServerTempDB;

Go

-- get the logical name of the file

Select *

From sys.sysfiles;

DBCC SHRINKFILE(logicalfilename, size);

Replace logicalfilename with the...

The downside to this is that your procedure could only be run for a single server at a time. Trying to run it from multiple connections will cause problems because...

How about using this:

ALTER DATABASE database_name

SET COMPATIBILITY_LEVEL = { 80 | 90 | 100 };

Florian Reischl (3/25/2009)

---

RBarryYoung (3/25/2009)

---

I do these kind of scripts (a lot) and I always concatenate them all together using either the Variable method or the XML method.

The Variable method is...

Yes - on a failover you would have to manually configure those tasks to include the partner database.

When reporting services is installed, the databases created use the default recovery model for that instance. Which is of course the recovery model defined on the model database -...

Flo, with all due respect I think you are working too hard to avoid using a cursor here. Administrative tasks such as creating users in a set of databases...

First issue - you have...