are you referring to the attach...

unless you have static ports set and connect directly to them, this negates the SQL browser service.

full backup once a week at the weekend and diffs during the week may work for you

This is not a suggestion, this how you carry out the upgrade 😀

Perry Whittle (1/9/2012)

---

However, if you really want to perform the upgrade you do so by first upgrading the...

Oracle_91 (1/8/2012)

---

Hi Everyone,

Can anyone help me out in know what is the procedure followed to upgrade 3 - node

sql server 2005 cluster to sql server 2008 on windows server...

DHCP is actually a good way to manage static IP assignments to servers as well as clients, its just never been supported until now (sql\windows 2008)

You can either use a static IP address or a DHCP assigned IP address. I'm assuming you mean DHCP when you say IP address on the domain controller.

If you assign...

Aww Jeff you're just too...

Certainly a (+) on 7 and 8...

Thanks for clearing that up

IIRC the older syntax is not supported in database compatibilty modes of 90 and higher

To set up mirroring in a workgroup see the following link

http://blogs.msdn.com/b/suhde/archive/2009/07/13/step-by-step-guide-to-configure-database-mirroring-between-sql-server-instances-in-a-workgroup.aspx

Is your laptop part of a windows domain. You need to be able to provide and resolve FQDNs?

To setup mirroring in a workgroup you need to take a different approach...

You must take and restore at least one...

winston Smith (1/8/2012)

---

That procedure relies on a detatch andreattach of the db, so it's not really a backup and restore of a tde database. It's moving of a tde database....