Forum Replies Created

Viewing 15 posts - 4,321 through 4,335 (of 9,241 total)

  • RE: Mirroring failover

    Richard Fryar (2/8/2013)


    This script checks all databases in one go, and avoids use of a cursor.

    Have you seen the code for sp_MSForeachdb????

    SQLCrazyCertified (2/8/2013)


    Is it going through each database that I...

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

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

  • RE: Mirroring failover

    SQLCrazyCertified (2/8/2013)


    Hi Perry,

    So, basically what it is doing is, it is creating the login using the SID of the user? and mapping it?..

    No, it's not!

    Its finding a database user and...

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

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

  • RE: Log Shipping Simple question re: full backup involvement

    sotn (2/8/2013)


    thanks for the all the replies,

    if no activity is performed for 12 hours (overnight) then does not seem make sense to perform 24 tlog backups with no real activity....

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

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

  • RE: Log Shipping Simple question re: full backup involvement

    GilaMonster (2/6/2013)


    even then a diff backup's usually easier.

    Providing a full backup hasn't occurred since the LS plan broke otherwise the Differential_Base_LSN is incremented and the Diff will no longer be...

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

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

  • RE: Migrate Virtual SQL Cluster to Physical Cluster

    Knut_knut (2/7/2013)


    ESX version (know its 4 or 5 not sure though)

    Important to know, there's big differences and improvements between 4.0, 4.1 and 5.1 😉

    Knut_knut (2/7/2013)


    How the disks are mapped

    You...

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

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

  • RE: SQL Log Shipping out of sync - Comparing Log shipping Primary and Secondary Servers

    george sibbald (2/7/2013)


    BTW, you don't need to reconfigure logshipping you can use your existing jobs and set up, just reinitialise the backup.

    You would be best pausing log jobs, taking a...

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

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

  • RE: Migrate Virtual SQL Cluster to Physical Cluster

    1 and 3 are essentially the same arent they?

    Knut_knut (2/7/2013)


    2. Install new servers, add them to the cluster, install SQL. Failover to the new nodes, shutdown the old machines.

    This method...

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

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

  • RE: SQL Always on, Domain user accounts for SQL Services

    In a Windows domain, domain user accounts are preferred. If you expect DC issues then the real issue is with your physical AD design\topology 😉

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

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

  • RE: Allways On database limitations.

    This from Microsoft themselves 😉

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

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

  • RE: How can I extract the setup files from the command prompt

    what are you trying to extract?

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

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

  • RE: SPN Settings

    The only time the auto registering of SPNs will work when running as a domain account is if the account is an administrator or it has been granted readServicePrincipalname and...

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

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

  • RE: SQL Log Shipping out of sync - Comparing Log shipping Primary and Secondary Servers

    Have you taken any full backups since LS broke, if not you may restart LS with a differential backup

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

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

  • RE: SQL Installation on D drive

    this is because some components are loaded at boot time. Logically, the only drive that is absolutely online during boot is the C drive 😉

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

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

  • RE: Disks are becomming offline after creating the cluster

    Where are the shared disks being presented from?

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

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

  • RE: Error while validating the cluster in wondows server 2008 R2 Using local storage

    The validation wizard should skip any local disks, can you supply more info on the server setups?

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

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

Viewing 15 posts - 4,321 through 4,335 (of 9,241 total)