So, if you have a public network connection with IP 192.168.1.30 and a secondary backup network with IP 10.10.10.30 and you copy backups to the backup server whose IP is...

you also need to take and restore at least 1 transaction log...

That's a problem, see my article at this link[/url]

Since the root disk becomes a dependency in the installed clustered instance group, create a...

rename windows server, then use sp_dropserver followed by sp_addserver.

Note you cannot rename the instance name only the...

are the drive\file paths identical on both servers?

what IP ranges do you have assigned to the NICs, what IP are you copying backups out to?

Why?

thelegendarywolf (4/9/2012)

---

The I.P. address changes will be for physical nodes only,...

make the root disk as small as possible, i usually use a size of around 100MB. See my article at this link[/url] for more info

Are the remaining drives separate or are they merely logical drives on the same physical disk(s) as the C drive?

What is the current total size and free space of the...

opc.three (4/9/2012)

---

If I have two data files in my database, both on D:\, and I want to move one to E:\ and one to F:\, if I run an alter...

The database would not come online!

The only time this would differ in any way is with file group...

If you'd bothered to read the code in the post it reads as follows

alter database DatabaseName set single_user with rollback immediate

go

-- Set databae Offline

alter database DatabaseName set Offline

go

--- Cut and...

opc.three (4/9/2012)

---

but having the database in single-user mode when it is brought online again is useful as it gives us a chance to run some verification checks on the database...

I've never tried it but I'm pretty sure you won't be able to use the upgrade wizard. The 2 are essentially the same eition with different licensing constraints. Having said...