Forum Replies Created

Viewing 15 posts - 6,856 through 6,870 (of 9,244 total)

  • RE: upgrade existing sql 2008 sp2 named instance to sql 2008 r2?

    its possible, but i'd go through it on a test system first if i were you to avoid hosing the production systems. Theres quite a bit to do here and...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: New drives added to the cluster is not being shown in restoring a database

    If you're clicking "add storage" it's a windows 2008 cluster. The storage dependency is set at the resource level not the group. To modify the dependencies on the SQL server...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Winows Server Questions

    This is exactly why i wrote my guide for creating a virtual sql server 2008 cluster. It gives you exposure to Windows fundamentals and helps you grow confidence

    Check the article...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2

    what was the domain name you used when creating the domain on the DC VM?

    what operating system have you used for the Clusterdc and the cluster nodes?

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: IN SSRS DEPLOYMENT

    I'm assuming you mean Report Manager URL and Report Web Service URL

    The web service URL is detailed at this link

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: page size in Sql Server

    Ramkumar (LivingForSQLServer) (7/6/2009)


    Guys,

    why Page size in Sql server is 8K? (why not 4K or 16K)

    and can we change default page size?

    Can anyone please clarify my doubt.

    Thanks in advance

    ram

    i'm stabbing in...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Error encountered during creation of databases: CREATE FILE encountered operating system error 5(Access is denied.)

    operating system error 5 is pretty clear. The SQL Server services user does not have access to the file\folder. Please check the NTFS ACLs and post a screenshot. Alternatively, use...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: I want to restart sql server cluster services What precautions should I take?

    providing your group dependencies are set correctly offlining and onlining the group will take all resources up\down as necessary. If you want to offline\restart just the clustered sql server service...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 1

    😉

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Copy of Production DB into Reporting DB on daily basis

    Log shipping would probably be your best option

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Deploy by using DBA-created databases (SharePoint Server 2010)

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

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Can we install SSRS on one server, and the corresponding databases on a different server?

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

    😎

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: HELP WITH WMI SCRIPTING

    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...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Can we install SSRS on one server, and the corresponding databases on a different server?

    jpSQLDude (7/19/2011)


    george sibbald (7/19/2011)


    yes

    Thanks! Care to share how?

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

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • RE: Creating a 2 Node SQL Server 2008 Virtual Cluster Part 2

    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...

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 15 posts - 6,856 through 6,870 (of 9,244 total)