Forum Replies Created

Viewing 15 posts - 3,196 through 3,210 (of 9,241 total)

  • RE: Database can't be in two Availablity Groups

    smallmoney (6/30/2014)


    I been trying to learn availability groups since I have not implemented it.

    Check my article at these links for more info

    Part1[/url]

    Part2[/url]

    Part3[/url]

    Part4[/url]

    smallmoney (6/30/2014)


    From my understanding you can have more than...

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

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

  • RE: Restoring Issue in 2012..

    Grant Fritchey (6/30/2014)


    As long as you have unique file names on a given server,

    It's not the server dictating this. You can have 100 databases all with the primary filename bob.mdf,...

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

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

  • RE: Restoring Issue in 2012..

    Chowdary's (6/30/2014)


    but without changing the names is there any chances?

    If you change the folder path then yes.

    I'm assuming you understand the concept of files and folders within a filesystem???

    The...

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

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

  • RE: Restoring Issue in 2012..

    Chowdary's (6/30/2014)


    Thank you for giving the Reply Mr.Lowell

    As i am using the Same system it may creates some problem i agree with you,

    But i had checked in other system which...

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

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

  • RE: Restoring Issue in 2012..

    Chowdary's (6/30/2014)


    Dear All,

    Am using 2008 and 2012 in my System.

    I have Question like the following.

    In 2008 i have taken the Full backup and can restored that Backup into the New...

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

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

  • RE: FULL --> SIMPLE --> FULL Recovery Model - SQL 2008 R2 Standard

    EdVassie (6/30/2014)


    The only way forward for your log shipping is to switch back to Full and send a new full backup to reinitialise log shipping.

    This is not entirely accurate, if...

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

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

  • RE: SQL 2012 Master database

    Bipsy (6/29/2014)


    Hi Experts,

    What exactly is a core differences between master database in SQL 2012 cluster instance and SQL 2012 standalone instance.Is master DB in SQL cluster instance holds any info...

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

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

  • RE: 2008 migration to 2012 and always on

    tcronin 95651 (6/26/2014)


    Ok I am considering moving what is currently a win 2008 sql 2008r2 activve/passive cluster that does log shipping to two servers, one for DR, the other for...

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

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

  • RE: best practice for remote connecing to SQL Server Express?

    Can you post a screen shot of the tcpip settings dialog in configuration manager

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

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

  • RE: Copying a database to another server instance options

    kevinsql7 (6/26/2014)


    Thanks Hema Kuman.

    I am also wondering if all three of these method (backup/restore, detach/attach, & copy database wizard) would automatically perform a database upgrade? For instance, if you are...

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

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

  • RE: FULL --> SIMPLE --> FULL Recovery Model - SQL 2008 R2 Standard

    No problem, as i said switch to bulk logged for the rebuild and you wont break the log chain, but the rebuild will still be minimally logged

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

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

  • RE: The cluster resource 'SQL Server' Could not be brought online

    jitendra.padhiyar (6/24/2014)


    Hello Sam,

    I am able to installed DTC. It was timezone issue. I set correct time zone and it works.

    Now I face new issue.. I installed MSSQL Server 2008 R2...

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

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

  • RE: FULL --> SIMPLE --> FULL Recovery Model - SQL 2008 R2 Standard

    lilywhites (6/25/2014)


    There is a 56GB table with a PK that needs to be rebuilt/dropped-created

    I'm assuming you're referring to rebuilding the clustered index that was created on the PK column?

    You don't...

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

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

  • RE: Best way to copy a database to another instance daily

    UconnDBA (6/26/2014)


    As far as overlay users I mean that the source and target will have different users/permissions. If we do a backup/restore the users at the target will now...

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

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

  • RE: Best way to copy a database to another instance daily

    UconnDBA (6/26/2014)


    Looking for what others have done to keep a copy of a database, for read only, on another instance. Need to do this once a day early in...

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

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

Viewing 15 posts - 3,196 through 3,210 (of 9,241 total)