Forum Replies Created

Viewing 15 posts - 7,096 through 7,110 (of 9,244 total)

  • RE: Performance issue: SQLServer2005 Consolidation on VMWare

    using virtual disks for the VMs SQL Server storage will be the weak point. For the SQL Server data storage drives they are better created as RDM's and ideally the...

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

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

    May 21, 2011 at 3:19 am

    #1328083

  • RE: Mirror between clusters

    BigSam (5/20/2011)

    I have a 2-node cluster that I want to migrate to a 3-node cluster with more storage and memory. The current 2-node cluster will be retired.

    Both clusters are running...

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

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

    May 21, 2011 at 3:05 am

    #1328079

  • RE: Problem connecting SQL Instance in a Single User Mode

    king_emperor_in (5/19/2011)

    Thanks for your reply, Well i did exactly the same thing on my local machine and it was fine.

    but if i will do that on my Production Server, wouldnt...

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

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

    May 21, 2011 at 3:03 am

    #1328078

  • RE: Logshipping -- What am I missing??

    GilaMonster (5/20/2011)

    You have another log backup job running?

    or someone\something is taking a log backup

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

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

    May 20, 2011 at 9:27 am

    #1327764

  • RE: Active/Active cluster... install SQL 2008R2 and also SQL Server 2008??

    2008 and 2008 R2 may reside on the same hardware

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

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

    May 20, 2011 at 7:53 am

    #1327687

  • RE: Drop All Users in the Database

    also you want to be using the sys.database_principals catalog view and not sysusers. This should be better

    declare @sql nvarchar(max)

    set @sql = ''

    SELECT @sql = @sql+

    '

    print ''Dropping '+name+'''

    execute master.dbo.sp_revokedbaccess '''+name+'''

    '

    FROM

    ...

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

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

    May 20, 2011 at 6:17 am

    #1327595

  • RE: Changed Server Windows name and now seeing different names using various sql queries

    you're welcome 😉

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

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

    May 20, 2011 at 6:13 am

    #1327593

  • RE: Yet another question about PAE AWE

    you're welcome 😉

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

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

    May 20, 2011 at 6:12 am

    #1327592

  • RE: Yet another question about PAE AWE

    bill 36362 (5/19/2011)

    So I have to upgrade server to Enterprise?

    Either upgrade to windows 2003 Enterprise 32 bit or windows 2003 Stndard 64 bit 😉

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

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

    May 20, 2011 at 12:42 am

    #1327490

  • RE: Yet another question about PAE AWE

    muthukkumaran (5/19/2011)

    Perry Whittle (5/19/2011)

    bill 36362 (5/19/2011)

    all 32 bit

    Standard 32 bit will only support a max of 4 GB RAM

    Perry,

    SQL 2008 32 bit supports Operating system maximum.

    It does indeed but...

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

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

    May 20, 2011 at 12:41 am

    #1327489

  • RE: Yet another question about PAE AWE

    bill 36362 (5/19/2011)

    all 32 bit

    Standard 32 bit will only support a max of 4 GB RAM

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

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

    May 19, 2011 at 5:53 pm

    #1327439

  • RE: Migrate Server 2008 R2 from VM to physical

    EdVassie (5/18/2011)

    My approach would be to do a standard side by side build and test of the new server.

    When it comes time to put the new server live,...

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

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

    May 19, 2011 at 4:35 pm

    #1327428

  • RE: Problem connecting SQL Instance in a Single User Mode

    king_emperor_in (5/19/2011)

    went to the SQL Server Configurations Manager and in Startup Paramaters i put "-m;" in front of the others.

    then re-started the service.

    wrong

    king_emperor_in (5/19/2011)

    Well I can only move TEMPDB database...

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

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

    May 19, 2011 at 4:29 pm

    #1327426

  • RE: Changed Server Windows name and now seeing different names using various sql queries

    bounceaball (5/19/2011)

    Our IT guy recently change the server name on my request from CSIADOLP1 to CSIADRPT01. I did use sp_dropserver and sp_addserver.

    I am seeing different results.

    I have attached the screenshot...

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

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

    May 19, 2011 at 4:07 pm

    #1327419

  • RE: Backup User Privileges for 3rd party backup

    have you checked the sql server logs

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

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

    May 19, 2011 at 4:00 pm

    #1327417

Viewing 15 posts - 7,096 through 7,110 (of 9,244 total)