Forum Replies Created

Viewing 15 posts - 481 through 495 (of 619 total)

  • RE: Changing the server collation

    Hey David,

    It looks like what you will need to do is follow option 1. There doesnt seem much point in changing the server collation and not rebuilding the sysdatabases.

    Is it...

  • RE: Tape Backup

    Hi there and HNY back.

    I dont use this feature currently and havent since LTO1 so cant really help, but have used tape backups in the past based on multiplel technologies...

  • RE: I could not shrink log file

    thinknight (1/5/2009)


    Unable to execute procedure. The database is not published. Execute the procedure

    in a database that is published for replication.

    Cannot shrink log file 2 (SC2_Log) because all logical log...

  • RE: I could not shrink log file

    Hi there,

    You have two choices here:

    1. Backup the log file and it will then allow you to shrink it.

    2. Backup the database, change the recovery model to 'simple', shrink the...

  • RE: Database Mirroring or Log shipping on different server

    Paresh,

    I've read this whole thread and agree with a past poster that there is some good but also some REALLY BAD advice here. I really would urge you to seek...

  • RE: How to shut down a SQL 2005 Failover Cluster ?

    Hey there,

    Ok so there are different ways but here's what I would do:

    1. Shut down Passive node (this will prevent a fail over).

    HERES WHERE ADVISE MAY DIFFER

    2. On the active...

  • RE: REAL Newbie - Admin name and Password

    Hi there, just reading you plight and the solution is really quite simple.

    1. Open up SSMS (SQL Server Management Studio).

    2. When it opens up you will have something like the...

  • RE: Time out occurred while waiting for buffer latch

    Sounds to me like the SAN is caching the transactions and not doing the write operation when the tran goes through. Therefore SQL thinks its done but it isnt.

    Check the...

  • RE: Time out occurred while waiting for buffer latch

    Hey everyone, I can see that no-one has put much on here for a while, but just fyi:

    We had a similar issue, ever since a reboot following some recent ms...

  • RE: Database mirroring

    Heye steveb,

    No latency is fine, cause it all running locally, plus the new test which work happens straight away.

    I think i just screwed up on past tests. Have always ...

  • RE: Database mirroring

    I just tested successfully. But the last two attempts failed. Now I'm not sure what to do.

    The BES databases in single (none replicated) mode runs as simple but when setting...

  • RE: Database mirroring

    How did you configure snapshots? Did you initialize?

  • RE: Database mirroring

    Don't know. By table addition, do you mean insert into or create table and add to publication?

    Insert into a table. Litteraly opening a table, adding a row and whatching...

  • 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...

Viewing 15 posts - 481 through 495 (of 619 total)