Log shipping would probably be your best option

from memory, the farm account will require at least dbcreator and securityadmin when creating content and search databases

Furthermore, please see my attached WIKI (in .doc format) detailing how to install, patch and configure an SSRS2005 instance 😉

😎

why are you using WMI?

To identify the virtual network name and the active cluster node name use the following

For cluster node name

select serverproperty('ComputerNamePhysicalNetBIOS')

For virtual network name

select serverproperty('machinename')

For instance name

select...

open reporting services configuration manager and when setting the SSRS instance details a set of database connection options are there, simply point to...

nalinabey (7/19/2011)

---

Hi Perry,

I was trying to set up domain controller and two VM's for this.I have a problem with assiging IP's for these three servers in order to create a...

No, the following will work for SQL Server 2000.

select ...

Which browser are you using?

Jeez, we're not still flogging this dead horse are we 😀

Could you provide more info on the iSCSI setup

don't disable the services, set them to manual startup and then use 'NET START' command to start the services. Incidentally, why is it taking so long for the storage to...

pshaship (7/18/2011)

---

My requirement is to have a dedicated Network IP for Database Mirroring set up. But I'm unable to configure it. I do have the separate IP address but how...

Marios Philippopoulos (7/5/2011)

---

For example, suppose that we have mapped login1 to dbRole1 .

Also suppose that role dbRole2 is also a member of dbRole1.

Implicitly, login1 is now mapped to both roles,...

are you aiming at just user created database roles or fixed roles too?

keyun (7/18/2011)

---

Hi,

What is the best method of updating your production server dbs from your development?

Currently, we are running daily process at night to backup our database and restore on...