Forum Replies Created

Viewing 15 posts - 3,781 through 3,795 (of 9,244 total)

  • RE: Log Shipping scans files but doesn't restore

    SQL_Bob (1/13/2014)

    Good question. This is a new setup so no it has never worked before (because it has never been attempted). However I can successfully restore the log backups manually,...

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

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

    January 14, 2014 at 8:45 am

    #1679945

  • RE: TEMPDB Configuration per vCPU

    growing data files in 64MB chunks is a really bad idea. Ideally create them to the size required including a little for contingency measures. If you must autogrow files and...

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

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

    January 14, 2014 at 7:40 am

    #1679904

  • RE: Understanding Peer-to-Peer Transactional Replication, Part 1

    Nice article John

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

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

    January 14, 2014 at 12:50 am

    #1679803

  • RE: More than 1 Distributor database per instance?

    SQL_ME_RICH (1/13/2014)

    Hi Perry - Thank you for the reply. I should have made my question a bit more clear...Can the instance which is holding the Publisher database utilize more...

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

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

    January 13, 2014 at 11:51 am

    #1679670

  • RE: Slow Disks After Cluster Creation

    Are these presented as Raw Device Mappings to the host server?

    Are the cluster nodes on the same host?

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

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

    January 13, 2014 at 8:39 am

    #1679605

  • RE: More than 1 Distributor database per instance?

    SQL_ME_RICH (1/8/2014)

    I've read that you can only have 1 distribution database per instance.

    A publisher will only use a single distribution database, if that's what you're referring too?

    SQL_ME_RICH (1/8/2014)

    Is there...

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

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

    January 13, 2014 at 6:55 am

    #1679567

  • RE: Splitting DBs into multiple files for IO spread

    Now now you two, no fighting 😀

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

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

    January 12, 2014 at 2:50 pm

    #1679472

  • RE: Always-On group question regarding instances...

    jasona.work (1/10/2014)

    I'm going to be playing with this, this weekend, but thought I'd ask about it as well.

    If I have two servers in an AO Group, can I have two...

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

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

    January 12, 2014 at 12:36 pm

    #1679462

  • RE: SQL Server FCI with Availability Groups (Cross site)

    deepak.uniyal (1/9/2014)

    Hello Friends,

    First a very happy new year to the whole community.

    As the new year opened, I have been given a challenge to create a two node SQL FCI (Production...

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

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

    January 12, 2014 at 12:24 pm

    #1679459

  • RE: system databases moving

    To corrupt a user database or the master database check my article at this link

    Are there any other errors from the windows app log?

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

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

    January 12, 2014 at 12:12 pm

    #1679458

  • RE: permission script

    sqlfriends (1/8/2014)

    Thanks, I cannot find any information on line about Public role has connect permission to a database.

    Could you provide a link that tells public role has connect permission.

    That's not...

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

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

    January 8, 2014 at 12:02 pm

    #1678536

  • RE: permission script

    yes it will have connect permission, it will also default to the public database role for access

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

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

    January 8, 2014 at 10:34 am

    #1678500

  • RE: permission script

    sqlfriends (1/7/2014)

    Thanks, it adds it to each database, but didn't grant any permission,

    But I guess it defaults to connect permission, that is just what the vendor product needs

    It will default...

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

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

    January 8, 2014 at 5:15 am

    #1678382

  • RE: Cannot increase database data file initial size

    thanks for posting back, this will certainly help others i'm sure

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

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

    January 8, 2014 at 5:10 am

    #1678379

  • RE: SQL rollback issues keep occurring due to lack of drive space

    mbrady (1/7/2014)

    The PRIMARY filegroup is set to Autogrow by 10 GB unrestricted on a drive with 770 GB free space remaining.

    Do you have the local security policy "perform volume...

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

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

    January 8, 2014 at 1:46 am

    #1678339

Viewing 15 posts - 3,781 through 3,795 (of 9,244 total)