Forum Replies Created

Viewing 15 posts - 5,596 through 5,610 (of 9,241 total)

  • RE: How to Create a Corrupt SQL Server Database

    dioscoredes (5/4/2012)


    Really enjoyed the article. Thanks. Great demo for my advanced training labs. Have done this in Oracle several times and is interesting to see how SQL server pages map...

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

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

  • RE: How to Create a Corrupt SQL Server Database

    Hi Michael, as the article mentions it's ideal for testing DBCC scripts against and also for practising dealing with a corrupt database.

    It also gives you an idea of what the...

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

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

  • RE: cluster exe remove preferred owners

    bangsql (5/2/2012)


    I used following cmd prompt to set preferred owners

    cluster group "Test" /SetOwners:Machine001

    However what is the command to remove preferred owners

    the below link not suggest anything

    http://technet.microsoft.com/en-us/library/cc723245.aspx

    The command I believe you...

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

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

  • RE: Backup and save a copy on a server on a different domain

    You're welcome

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

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

  • RE: Clustering Services

    How many cluster nodes?

    What quorum type?

    Are you required to shut down the clustered SQL server instance or the cluster node(s)?

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

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

  • RE: Clustering Services

    Whisper9999 (4/30/2012)


    Okay, I'm confused. Let's say someone tells me to shut down "clustering services" on an active/active 2005 cluster. Where do I find it and how do I...

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

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

  • RE: upgrade path to sql server 2012 entreprise

    zetchi (5/1/2012)


    is there anything special to do or to install before installing sp1 ?

    thank you

    apart from the obvious, check you have backups before starting, no. Install the service pack and...

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

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

  • RE: Backups and log shipping

    dixon_dwayne (4/30/2012)


    Question is: after initial full backup on prod box and all the transaction logs created on prod box, do I need to keep them or can they be...

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

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

  • RE: upgrade path to sql server 2012 entreprise

    check this link on the Microsoft website

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

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

  • RE: RAID and Its impact on your SQL performance

    derek.colley (5/1/2012)


    Would have been nice to explore the topic of 1) virtualisation and 2) SANs and how the IOPS rates differ when using these different technologies. Any more articles...

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

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

  • RE: RAID and Its impact on your SQL performance

    Nice article, incidentally RAID 1+0 and 0+1 are not identical. As 0+1 is essentially 2 stripes the loss of 1 disk in each portion of the array is catastrophic. 1+0...

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

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

  • RE: Prerequisites for clustering

    mohan.bndr (4/29/2012)


    Hi,

    Can i know what are the prerequisites for Cluster Environment please....

    Thanks,

    Windows Server 2008 Enterprise or above.

    Sufficient shared storage solution.

    Identical node hardware

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

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

  • RE: Why is BACKUP DATABASE working for Transaction Log backups?

    Hans Lindgren (4/30/2012)


    should require a RESTORE LOG and not a RESTORE DATABASE.

    Anyone knows why this seems to work?

    That's because the command that will run is a log restore, i ran...

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

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

  • RE: Can you restore a 2008 DB to 2005?

    Dev (4/29/2012)


    It would be lot easier than Export / Import Data Task.

    huh, how do you work that out, they both have the same end result, execute an SSIS package!!

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

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

  • RE: Database log file changed name

    wmlbill (4/26/2012)


    SQL Server 2008 log file named changed

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

    Hi all,

    Some how the log file name on one of my databases changed from dbname_log.ldf to dbname_1.LDF Can anyone explain why this happened?...

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

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

Viewing 15 posts - 5,596 through 5,610 (of 9,241 total)