Forum Replies Created

Viewing 15 posts - 7,906 through 7,920 (of 9,244 total)

  • RE: configure sql server

    it all depends on

    32 bit or 64 bit

    memory available

    CPUs available

    SQL Server edition

    and others besides. For example, What is the servers intended workload?

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

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

  • RE: Table bifurcation in sqlserver

    if for some reason this table does not have a clustered index then simply create into your new filegroup, either way if it is a large table this could take...

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

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

  • RE: Sqlserver Report server's HTTP 500 Internal Server Error

    hi

    sorry, not screenshots of the web pages. Screenshots of the sections in report services configuration manager

    configuring IIS and service accounts are way beyond the scope of a post in this...

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

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

  • RE: Best practice when moving data from old storage to the new one

    pavleesseck (6/2/2010)


    I will try this solution on my simulating SQL cluster in VMware Infrastructure 3 first. 🙂

    good man, was gonna be my next suggestion 😉

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

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

  • RE: Sqlserver Report server's HTTP 500 Internal Server Error

    NazerMohamed (6/2/2010)


    Good that I at least found out that SSRS 2008 does not require IIS. I was thinking it still uses IIS as SQL 2005.

    My installation of SSRS is in...

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

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

  • RE: Best practice when moving data from old storage to the new one

    presumably you are currently presenting these over iSCSI?

    You would need agreed downtime for your cluster there's no getting away from that.

    I would create the new LUNS and attach them...

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

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

  • RE: Sqlserver Report server's HTTP 500 Internal Server Error

    Hi

    couple of questions.

    is IIS installed\configured on this server (do you have any websites)?

    Are you using a service account for the SSRS service?

    Can you post some screenshots for web service URL...

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

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

  • RE: SQL SERVER 2005 Restore Backup database

    is the backup they have sent you definitely a full backup? Post the results of the following query

    restore headeronly from disk = 'drive:\path\backupfilename.bak'

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

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

  • RE: SQL 2008 Clustering on a VMWare Environment

    CavyPrincess (6/1/2010)


    I've installed SQL Server Clustering, but not Windows Clustering using VMWare

    Hi Cindy

    glad you found it useful. Remember that clustering is totally separate to SQL Server. SQL Server merely makes...

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

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

  • RE: 890219 - Cluster IP Address gets a barrier

    Bingo, you got it. 😉

    Well done!

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

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

  • RE: Need to run the Statement to attain the list of users in SQL 2008

    you may want to try posting in the correct forum in future 😉

    The database table you need to query is sys.database_principals, this script should help!

    use yourdb

    select 'Login name : '...

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

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

  • RE: Delete Vs Truncate

    Jeff Moden (5/27/2010)


    Just don't throw the book at me. 😛

    No give him a taste of his own medicine and throw a few pork chops instead 😀 :laugh:

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

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

  • RE: Instance not selectable when trying to remove node from a cluster

    when you get the error

    are you creating a failover cluster instance or adding a node to a failover cluster instance

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

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

  • RE: SQL 2008 Clustering on a VMWare Environment

    Hi

    Check my tutorial at the following link for installing a SQL Server 2008 clustered instance under VMWare Server 2.0!

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

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

  • RE: Instance not selectable when trying to remove node from a cluster

    which version of SQL Server are you attempting to cluster?

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

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

Viewing 15 posts - 7,906 through 7,920 (of 9,244 total)