Forum Replies Created

Viewing 15 posts - 301 through 315 (of 441 total)

  • RE: Suspending Database Mirroring

    Perry Whittle (12/28/2012)

    SQLCrazyCertified (12/27/2012)

    Does anyone know what else can cause the mirroring to be in a suspended state?

    SueTons.

    Creating a new file on the principal when the file paths between the...

    December 28, 2012 at 6:40 am

    #1572096

  • RE: Suspending Database Mirroring

    Perry Whittle (12/28/2012)

    SQLCrazyCertified (12/27/2012)

    Does anyone know what else can cause the mirroring to be in a suspended state?

    SueTons.

    Creating a new file on the principal when the file paths between the...

    December 28, 2012 at 6:38 am

    #1572094

  • RE: Suspending Database Mirroring

    Perry Whittle (12/28/2012)

    SQLCrazyCertified (12/27/2012)

    Does anyone know what else can cause the mirroring to be in a suspended state?

    SueTons.

    Creating a new file on the principal when the file paths between the...

    December 28, 2012 at 6:38 am

    #1572093

  • RE: Sql Server 2012 LocalDb deployment

    bwagenbach (12/21/2012)

    I have researched the Internet but cannot get a complete answer or instructions. I have seen this asked in a few other forums. What is the deployment process for...

    December 27, 2012 at 11:23 am

    #1571951

  • RE: Suspending Database Mirroring

    Preet_S (12/20/2012)

    Hi All

    Does anybody know if suspending db mirroring prevents automatic failover should the primary fail ?

    I know that Suspending stops transactions being sent to the mirror and the principal...

    December 27, 2012 at 8:53 am

    #1571893

  • RE: Log File Size Issue

    GilaMonster (12/26/2012)

    SQLCrazyCertified (12/26/2012)

    So, by doing that automatically truncate the logs?

    Yup, as soon as a checkpoint runs. In this case it won't be able to actually truncate the log, due...

    December 26, 2012 at 3:08 pm

    #1571691

  • RE: Log File Size Issue

    OP mentioned he changed the recover model to simple.

    So, by doing that automatically truncate the logs? Or does he need to truncate it manually?

    SueTons.

    December 26, 2012 at 2:09 pm

    #1571673

  • RE: Log File Size Issue

    Some times you need to do log backups couple of times in order for the inactive logs to be truncated.

    So, do that coupi of time and also you can shrink...

    December 24, 2012 at 7:24 pm

    #1571391

  • RE: Script to Grant differen Permission to SP, Scalar, Table-valued and inline functions.

    Thanks Lowell, appreciate for your quick response.

    SueTons.

    December 19, 2012 at 12:50 pm

    #1570279

  • RE: Ways to move only table data in database?

    mpradeep23 (12/18/2012)

    Hi

    i have two databases in different instances i need to transfer data between two tables are by querry can any one specify the ways for the above...

    December 18, 2012 at 7:56 am

    #1569588

  • RE: Access table from different instance

    Zeal-DBA (12/14/2012)

    ok thanks a ton for your help 🙂

    Did openrowset works for you?....I am curious.

    SueTons.

    December 16, 2012 at 6:04 pm

    #1568984

  • RE: How to install an oracle linked server on SQL Server 2008 r2 failover cluster manager

    APA0876 (12/14/2012)

    How to install an oracle linked server on SQL Server 2008 r2 failover cluster manager

    I'm reading some articles and applying them but with no result.

    First of all where can...

    December 16, 2012 at 6:01 pm

    #1568982

  • RE: SQL 2008 CLustering

    raheelr 63130 (12/16/2012)

    Team, I need to set-up clustering and need your thoughts and ideas whether i should have my primay server on physical and secondary on virtual or both virtual...

    December 16, 2012 at 5:30 pm

    #1568977

  • RE: Find Failed Jobs

    Thanks to both of you. Appreciate it.

    SueTons.

    December 12, 2012 at 2:12 pm

    #1568072

  • RE: Upgrade from 2005 to 2008

    jerry-621596 (12/6/2012)

    Don't use that option. Restore with recovery so that SQL 2008 can run the various stored procedures that upgrade the database structure to the new format.

    Then change the...

    December 6, 2012 at 3:08 pm

    #1566366

Viewing 15 posts - 301 through 315 (of 441 total)