Forum Replies Created

Viewing 15 posts - 6,451 through 6,465 (of 9,241 total)

  • RE: License questions

    In SQL Server 2008 R2, developer is licenced and featured the same as datacenter. You can have as many testers connect as required. The key point of the licence terms...

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

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

  • RE: License questions

    Sorry my bad yes,

    2008 R2 datacenter edition unlimited VMs.

    2008 R2 enterprise edition up to 4 VMs.

    However, you will find that what I stated above otherwise is correct.

    Think, there is...

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

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

  • RE: How To restore/attach DB with alternate mdf file (holds indexes only)

    YSLGuru (10/6/2011)


    I was hoping that since the corrupt/missing mdf file stored only indexes and no table data or other DB schema objects

    I think everybody knows where i'm going with this...

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

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

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

    the 3 services for Authorisation, Host and Web server access need to be started 😉

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

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

  • RE: GUI Restore Database Did Something Odd

    it is impossible to have 2 files named exactly the same within Windows and SQL Server doesn't have anyway of circumventing this. Generally the restore will name the OS files...

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

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

  • RE: Monitoring free space in a mount point

    you can also use wmic as follows

    wmic volume get label, "free space", name, capacity, "drive letter"

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

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

  • RE: How Do You Handle Database Documentation?

    All of my deployments are generally documented as a combination of Visio diagrams and Word docs detailing the complete setup from host names and IP addresses to storage.

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

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

  • RE: License questions

    dmoutray (10/7/2011)


    The exact wording in the Microsoft document is "Each Server License for SQL Server 2008 R2 Enterprise permits you to run the software in up to four (4) Operating...

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

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

  • RE: SQL Server 2008 R2 SP1 download

    Brian Brown-204626 (10/7/2011)


    When I go to the download screen for R2 SP1, in addition to the I64, x64 and x86 file, there are two files for Management studio. Does...

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

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

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

    you could use the Windows 2008 eval or sign up for a Technet subscription 😉

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

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

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

    mohammed moinudheen (10/8/2011)


    today after restarting my laptop I was unable to logon to the VMWare server home page. I am not sure what was the reason.

    did you check the VMWare...

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

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

  • RE: database is in suspect mode (sql server 2008 R2 version)

    CHECKDB will rebuild the transaction log too, complete description is here

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

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

  • RE: Multiple Databases Mirroring Script Fails

    Lynn Pettis (10/6/2011)


    The key to your problem is the spaces in the database name. You need to surround the name with [], just like you would with column names...

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

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

  • RE: What options are out there when Prod SQL Network and Standby SQL Network names are different and you need to failover quickly

    parissa_bakhshi (10/8/2011)


    Think it's not a real cluster when you have different network names. What was the reason for using different network names for SQL resources? You can install a new...

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

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

  • RE: Change Subnet Mask of Cluster on SQL 2008

    amenjonathan (10/6/2011)


    Is there a way to change the subnet mask of the cluster without dropping and re-adding the IP? I've got the IP properties window open, and the subnet mask...

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

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

Viewing 15 posts - 6,451 through 6,465 (of 9,241 total)