Forum Replies Created

Viewing 15 posts - 496 through 510 (of 620 total)

  • RE: Database mirroring

    Nicholas Cain (12/5/2008)


    By BES replication do you mean the replication within Blackberry Enterprise Server?

    Sorry no, this is database replication for dr purposes.

  • RE: Database mirroring

    Gail: BES is Blackberry Enterprise Server

    According to the instructions from the BlackBerry web site, for DR purposes you have to setup Transactional Replciation (there is a script to run which...

  • RE: Database mirroring

    GilaMonster (12/5/2008)


    Schadenfreude-Mei (12/5/2008)


    So its only Transaction Replication that needs Full/Bulk? I didnt know that i thought it was Replication in general.

    No. As I said above

    Replication does not require any particular...

  • RE: Database mirroring

    GilaMonster (12/5/2008)


    Schadenfreude-Mei (12/5/2008)


    To allow replication you db must be in Full or Bulk recovery model.

    Replication does not require any particular recovery model. All forms of replication (snapshot, transactional, merge) work...

  • RE: Integraton Services not connecting through Management Studio

    Ignacio A. Salom Rangel (12/4/2008)


    Javier, just to be sure, Are you able to connect to Integration Services from the first node?

    Which node are you connecting from? My understanding of your...

  • RE: SQL Server 2005 64-bit Total Server Memory(KB)

    I run a similar A/P cluster, running 64-bit Enterprise.

    Each node has 64GB of memory. At pressent the active node is using 14GB of memory (even though it has been capped...

  • RE: Database mirroring

    GilaMonster (12/5/2008)


    Consider transactional replication rather.

    Mirroring is a high-availability solution, not for reporting.

    If you think you will be updating B regularly or making changes to the databases, this could...

  • RE: disable shutdown button

    And in response to kevriley, I think you likely get in hot water for making changes to Local Security as it would effect all none admin users of that server...

  • RE: disable shutdown button

    Dont really understand why your putting this popst in a SQL Admin forum?

    What is your role, am gonna assume third line or applications support. That being the case,...

  • RE: MSSQL 2000 and 2005 COEXIST on CLUSTER??

    Never tried. Good luck 🙂

  • RE: Moving from 2000 to 2005 on a different box

    Easy mistake to make. The backups will alway try to restore back to their old location (same withh attaching as well).

    One more thing, ensure to move any SQL2K5 or SQL2K...

  • RE: GP & Database Mirroring

    Your too quick Steve, was just gonna say that. Though prob not so eliquently :s

  • RE: Error on completion of backup job

    Sakthivel Chidambaram (11/21/2008)


    Hi,

    Try enabling below Trace Flags

    DBCC TRACEON(3213, 3605, -1)

    to Log any Exception message and much more detailed information about the backup process in...

  • RE: Error on completion of backup job

    Sakthivel Chidambaram (11/21/2008)


    This error indicates that the destination path to which you are taking backup does not exist or the account used to connect to the path (SQLSERVER AGENT SERVICE...

  • RE: SQL-2005 Installation on an existing SQL-2000 server

    tomas.mortensen (11/21/2008)


    Hi .. we are also going to add a sql 2005 instance on a server with sql 2000 named instance (B).

    So im gonna share my pitfalls if any .....

Viewing 15 posts - 496 through 510 (of 620 total)