All depends on how much data is stored and for how long. I'd imagine a bank like Bank Of America databases are probably big >TB (just a guess) compared...

Probably already know this but... if you installing SQL Server 2008 on cluster will need to slipstream a service pack.

http://support.microsoft.com/kb/955392/

SSIS Transfer Logins task works well.

I agree with Gila Monster but if you really need to you can create a .bat file and then set it up as a scheduled task.

NET STOP SQLSERVERAGENT

NET STOP MSSQLSERVER

NET...

It is a version of SQL Server i.e. Devleoper, Standard etc. See below sites for information

http://www.microsoft.com/sqlserver/2008/en/us/editions.aspx

http://www.microsoft.com/sqlserver/2008/en/us/web.aspx

Yes. You will need to apply SP4 before upgrading. If possible try and get new hardware and do a side by side upgrade.

check the firewall. Also from the client machine try a telnet test

telnet <servername> 1433

Here is good documentation on it.

http://www.mssqltips.com/tip.asp?tip=1687

Try using the Transfer login task in BIDS and be sure that "Copy Sids" is set to True. It worked great for my side by side upgrades.

Looks like you need to JOIN orders and OrderDetails. Something like this:

Select *

From Orders

JOIN Orders on OrderDetails.OrderID = Orders.OrderID

WHERE Orders.OrderStatus in ('Pending', 'Processing', 'New')

Create Active Directory Security Groups and add the users to those security groups. Then apply appropriate permissions in reporting services to those security groups.

Is the "separate disk" on same server? Same domain? Does the owner of the backup job have permissions?

I just installed Visual Studio 2010 and it has compare functionality built in. It is pretty nice.

You could download the 14 day trial for Idera SQL Admin toolset which can get you that information quickly. I bought it for $200 and use it all the...

Here is what I do.

1. Create a Credential in SSMS under security (needs to have access to the remote server)

2. Create a Proxy in SSMS under SQL Server Agent to...