Forum Replies Created

Viewing 15 posts - 3,001 through 3,015 (of 4,745 total)

  • RE: Transactional Replication Stalls when mirror offline

    just noticed you have enterprise edition. You can use asynchronous mirroring with that. Unless you need automatic failover you should consider changing to asynchronous mode (high performance or safety off).

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

  • RE: Transactional Replication Stalls when mirror offline

    its not a problem, its by design.

    with synchronous mirroring the transaction has to be committed on the partner before it can be committed on the primary. so whilst the partner...

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

  • RE: Help - Cannot recover the master database. Exiting.

    can I suggest that once you get you master database back you copy the system database files off to another location. then if you are in this situation again you...

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

  • RE: SQL2005 32 bit to 64 bit migration path

    I'd certainly want to test it first in a sandpit environment.

    Only sensible to have scripted out objects as a fall back position, and backup the x64 system dbs first. I...

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

  • RE: SQL2005 32 bit to 64 bit migration path

    don't know about heavy hitter, does the occasional home run count? 🙂

    This blog would suggest you can restore X86 system dbs to 64bit

    http://blogs.technet.com/keithward/archive/2009/10/15/upgrading-sql-server-from-32bit-to-64bit.aspx%5B/url%5D

    there seems to be a possible msdb bug,...

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

  • RE: Failover Failed

    luckysql.kinda (1/28/2010)


    But one question... What about HIGH SAFETY (WITHOUT WITNESS). This is also sync. So according to me we can use ALTER DATABASE SET PARTNER FAILOVER. M I Correct?

    -Lucky

    you are...

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

  • RE: Split database files into multiple files in same FILEGROUP

    if the disk is raided create a new file, it will fill, you will still see a performance benefit.

    If you can have the file on a different drive will see...

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

  • RE: Split database files into multiple files in same FILEGROUP

    SQL fills files on a proportional fill basis. i.e it tries to keep all files in a filegroup equally full, which means it would tend to write more to a...

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

  • RE: Failover Failed

    either use 'allow data loss' or if that is not acceptable switch to high safety mode, allow it to synchronise and then do alter database set partner failover

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

  • RE: Split database files into multiple files in same FILEGROUP

    If you want to define which object goes to which file, specifying new filegroups is the only way.

    If files are all part of the same filegroup SQL will just spread...

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

  • RE: Log Shipping - Best practices

    If you start logshipping the log backups done as part of that process should be the only log backups you do.

    If you have other log backups not done by the...

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

  • RE: Disaster recovery in SQL 2005 - which one is better ?

    what about asynchronous mirroring? Perhaps they should improve their network.

    I would never use replication for DR, thats not really what it is intended for.

    which leaves log shipping or replication at...

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

  • RE: SQL Server 2005 server login worked, then did not

    crossmj (1/26/2010)


    If I removed the new sql services account from the Builtin Admins group, would that compromise the account's credibility with Sql Server?

    No. You should find the account is...

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

  • RE: SQL Server 2005 server login worked, then did not

    builtin\administrators is more rights than it strictly needs.

    did you use SQL configuration manager to assign the new user as the service account? That would automatically assign it all rights it...

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

  • RE: delete all Tlog backups following a successful full DB backup

    I agree too.

    What are the 'current circumstances'?

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

Viewing 15 posts - 3,001 through 3,015 (of 4,745 total)