Mirroring will not work from SQL 2008R2 to SQL 2005 and neither will log shipping. However, replication could be the solution for you since it will work with a 2008R2...

Install the SQL Server 2008 Native client from this page on each client.

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=228DE03F-3B5A-428A-923F-58A033D316E1&displaylang=en

This will install the new ODBC drivers for SQL 2008.

I'm not sure if this applies to SQL 2008 but I was bit by this doing a rolling upgrade from SQL 2005 to SQL 2008R2.

If you plan on using the...

Paul has a blog about...

MS provides a couple stored procedures to do just that:

http://support.microsoft.com/kb/246133/[/url]

You should always set max memory for SQL Server to something less than the max memory on the machine. If not, SQL could potentially consume all the memory on the...

SQL 2008 and...

Did you add the new LUN to the cluster group and define the dependency on it for the SQL Server service to start?

We recently got a mobile app in house from Rove. It piggy backs on the secure Blackberry network so no VPN connection is needed. You can run cmd, powershell, RDP,...

CirquedeSQLeil (11/15/2010)

I agree. Physical activity such as working out tends to help me get over the mental burnouts. I actually feel like I...

This should do the trick assuming the views and sprocs you want them to see are all in the dbo schema.

GRANT VIEW DEFINITION ON SCHEMA::[dbo] TO [sqluser]

GO

Right click the db>Reports>Standard Reports>Disk Usage

or to see the log info for all databases

dbcc sqlperf(logspace)

Yes, you can connect to SQL 2008 servers with SSMS 2005 provided you have it patched to SP2 CU5 or greater. As David said, you will not be able to...

If you compress a table the data written to that table will be compressed also but compressed indexes, clustered or non-clustered, require the same maintenance as uncompressed indexes. ie; you...

If the database is in simple recovery mode you can use something like:

USE <dbname>

GO

CHECKPOINT

GO

ALTER DATABASE <dbname> REMOVE FILE dbname_log2

GO

Or if it's in full recovery mode you will need to...