Forum Replies Created

Viewing 15 posts - 1 through 15 (of 15 total)

  • RE: 2012 always on and reporting

    Found it: Thanks for information

    Primary Replica RCSI or SI Enabled, Secondary Replica Not Read Enabled

    In this instance, SI and/or RCSI are enabled on the primary replica but the secondary replica...

  • RE: 2012 always on and reporting

    Woah! That is worrying. Part of the over all solution is to off load your backups, DBCC work, and reporting. So if I am reading you correctly, what you are...

  • RE: 2012 always on and reporting

    (log shipping ref:) sync set up, every replica needs to have access to a shared location to access the database backups created and used for synchronising the secondary databases. The...

  • RE: 2012 always on and reporting

    That's an interesting read. Thanks for this.

  • RE: 2012 always on and reporting

    MyDoggieJessie, sure.

  • RE: 2012 always on and reporting

    Understood. I'm still finding my feet with this. I was referring to AlwaysOn using SQL Server’s existing mirroring technology, and therefor I need a location for the initial full syn...

  • RE: 2012 always on and reporting

    HI Gianluca, This is what I was hoping to here. Thanks for your comment.

  • RE: 2012 always on and reporting

    Your dead right about the licensing Andrew.

  • RE: DR solution

    I agree with you regarding the convoluted approach to this. As the operating system and SQL install are not replicated via the SAN...so there is no other option...at least in...

  • RE: DR solution

    Sure, if every thing is the same it should work. The only difference here is the SQL install of the system databases will not be on the SAN on the...

  • RE: DR solution

    restoring the master and MSDB from one SQL Instance to another with the same name will work? What about the pointers of the user database location...orphaned users etc (SQL2000/SQL2005)...i don't...

  • RE: DR solution

    Thanks for responding,

    DNS aliasing is not an option due to inflexible application...there's a lot of cool stuff I want to use however there are tight constraints such as SPs referring...

  • RE: DR solution

    Yes, on the secondary - for want of better word - the virtual server will be renamed to match the primary machine's name (this is because of application connectivity) in...

  • RE: Log shipping & DBCC SHRINKFILE ('Database', 13) is it safe

    If it helps, I had firstly "TESTED" my approach and it did work. The primary and the remote databases were shrunk and log shipping restores to the secondary continued. The...

Viewing 15 posts - 1 through 15 (of 15 total)