Forum Replies Created

Viewing 15 posts - 6,631 through 6,645 (of 9,244 total)

  • RE: Detach/Attach method of upgrading SQL 2000 to SQL 2008 R2

    Andrew Notarian (9/8/2011)


    Is there any reason we might not want to use the offline detach at old server /re-attach at new new server method of migrating from SQL 2000 to...

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

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

  • RE: add second node

    how many nodes form the base windows cluster?

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

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

  • RE: Clustering Setup Help Needed!!

    my 3 part guide details all. See the first part at this link[/url]

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

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

  • RE: litespeed bkup n restore...refresh database prod to dev

    AAKR (9/7/2011)


    I need documentation on this if any one have the documentation or any links on this.... plsss ..

    thankyou advance...:-)

    how are your backups currently taken through litespeed, litespeed maintenance...

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

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

  • RE: Error 1394 when backup plan is executed.

    For me, backing up across a network is just asking for trouble. I prefer local then mirroring out as necessary

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

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

  • RE: SQL 2005 Max Memory Setting on Cluster

    ALZDBA (9/8/2011)


    SpringTownDBA (9/7/2011)


    short answer:

    DB1, min 6-7 GB, unlimited max

    DB2, min 3-4 GB, unlimited max

    as it is currently configured, you have 40 GB of ram and only 18 GB can...

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

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

  • RE: Mirroring partner timeout - Not working the way advertised?

    What command are you using to change the timeout?

    What does this return when run against the principal

    select db_name(database_id),

    mirroring_connection_timeout...

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

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

  • RE: Cluster Validation fails to check Storage

    What storage mediums are you using?

    Local disks, San, etc

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

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

  • RE: script to synchronize sid for login and users

    I bulk copy the syslogins table to a file and transfer to my DR server. On the dr box I import to a temp table and where the user in...

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

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

  • RE: Strange SQL Cluster 2008 situation

    I've never had a problem using NIC teaming for the public NICs.

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

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

  • RE: Error 1394 when backup plan is executed.

    Can you backup to a local drive ok?

    Is this a typo?

    \\servername/sharedfolder/xxx.bak'

    if so it should be

    \\servername\sharedfolder\xxx.bak'

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

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

  • RE: Group Policy - User Rights Asiignment

    sqlbanana (9/7/2011)


    1 Adjust memory quotas for a process

    http://technet.microsoft.com/en-us/library/cc736528(WS.10).aspx

    sqlbanana (9/7/2011)


    2 Bypass traverse checking

    http://technet.microsoft.com/en-us/library/cc739389(WS.10).aspx

    sqlbanana (9/7/2011)


    3 Lock Pages in memory

    http://technet.microsoft.com/en-us/library/cc783969(WS.10).aspx

    sqlbanana (9/7/2011)


    6 Replace a process-level token

    http://technet.microsoft.com/en-us/library/cc784623(WS.10).aspx

    most of them are fairly obvious, for instance unless...

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

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

  • RE: Which SQL Server version to buy?

    Floob (9/6/2011)


    Hi,

    I'm trying to confirm the right version of SQL server.

    I'm after SQL Server 2008 Standard - 5 cal.

    Does anyone have a link to a UK supplier of this?

    Thanks

    http://uk.insight.com/en-gb/searchresults/software/server-applications?K=&M=&2713v=&400557v=Business+-+databases+%2F+database+tools&400536v=

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

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

  • RE: About Performance

    ESAT ERKEC (9/7/2011)


    nic large receive offload is enable it is decrease sql server performance any one have any experience about it? why?

    This link may be of some help

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

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

  • RE: Database in Restoring State

    to configure database mirroring for servers in a workgroup you will need to follow this link as the GUI tries to use Windows authentication only

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

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

Viewing 15 posts - 6,631 through 6,645 (of 9,244 total)