Forum Replies Created

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

  • RE: Re-establish mirroring after DR test

    Perry Whittle (1/29/2015)


    Calvin Duffy (1/29/2015)


    No full backup was taken after the mirroring broke.

    If a full backup has occurred on the principal since mirroring broke you're stuck with re iinitializing...

  • RE: Re-establish mirroring after DR test

    Perry Whittle (1/29/2015)


    So, has a full backup been taken on the principal since the mirroring broke?

    Use this query against the principal and then the mirror to ascertain if it has...

  • RE: Re-establish mirroring after DR test

    Perry Whittle (1/29/2015)


    Calvin Duffy (1/27/2015)


    The mirroring type is "High Performance (asynchronous)". There are no witness server(s). Need to write to the database (Mirroring db not the primary db). Can't do...

  • RE: Re-establish mirroring after DR test

    S. Kusen (1/27/2015)


    If you break the mirror and set partner off, the LSN needs to get back into sequence for mirroring to pick back up. We've always just done...

  • RE: Re-establish mirroring after DR test

    The mirroring type is "High Performance (asynchronous)". There are no witness server(s). Need to write to the database (Mirroring db not the primary db). Can't do role switching. Can't take...

  • RE: SQL Server 2000 DTS/Stored Proc Mystery

    Thanks..........I think I'll try trace (Not server side) since I know exactly when the process fails and the workload of the server is light at that time.

  • RE: SQL Server 2008 Cluster Installation

    Nope.............See here.......

    http://msdn.microsoft.com/en-us/library/ms189134.aspx

    "All nodes in a failover cluster must be of the same platform, either 32-bit or 64-bit, and must run the same operating system edition and version. Also, 64-bit SQL...

  • RE: Rights to create DTS package

    Deny execute permission on the "sp_add_dtspackage" stored procedure in msdb database. They can still create DTS packages but NOT save it on the server. They can save it as a...

  • RE: DB - File Storage BI question (I think !)

    Thanks..................

  • RE: DB - File Storage BI question (I think !)

    "A couple of Project Management applications that I know support this feature as letting the user to download and upload files. Users edit files themselves. "

    How ?...

  • RE: C-2 and other auditing

    These are some of them but I am not sure about any of them creating a log file that can be archived/viewed in need. I would do the C-2 auditing...

  • RE: Can't drop database.....

    Expand Management and double click on the "Activity Monitor". If you see the database name under the "database" column, right click on it and choose "Kill Process" to kill the...

  • RE: The Indian Yes

    " I agree, America is the center of the known universe. As soon as the rest of the world adopts American culture and values the better."

    That is the biggest bull...

  • RE: SSIS No Such Interface

    And I fixed this problem by re-installing SP2 with "Distributed Transaction Coordinator" service up and running under the "NT AUTHORITY\NetworkService" account.

    The DTS service has to be up and running while...

  • RE: Connect to SSIS Service on machine failed

    I have the exact same problem. If you find a solution please let me know.

    Thanks.

    Calvin Duffy.

    frx65@hotmail.com

     

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