Forum Replies Created

Viewing 8 posts - 61 through 68 (of 68 total)

  • RE: Hiding column information

    Are you talking about preventing normal users access to viewing the table structure (columns etc.)?

  • RE: SQL2005 File Size did not update

    Load Management Studio

    Expand Databases

    Right-click on your database

    Choose Reports, Standard Reports, Disk Usage

    Check out how much "unallocated" space (as a %) is in the file. Until this is basically zero...

  • RE: log full

    With the ratio of data to log file size I'm going to guess your database is in full mode and you haven't been backing the log up. This causes...

  • RE: Database Mirroring Sql 2005 Standard

    Full Safety ON (from the mirror with the database being master)

    ALTER DATABASE SET PARTNER OFF

    RESTORE DATABASE WITH RECOVERY

    Full Safety OFF (I think)

    ALTER DATABASE SET...

  • RE: Verifying LogShipping in SQL 2005

    A very simple way to check your logshipping is working is to make a small change in one table on the primary and see if it appears on the secondary...

  • RE: Log Shipping Works, Copy says it''''s failed

    They're all set to use the same schedule (of every 10 mins) .  I'm guessing the job claims to have failed

  • RE: Log Shipping Works, Copy says it''''s failed

    According to the monitoring server, the latest file copied and restored was 14:40

    BUT

    Going to the physical C drive location of the secondary where it's dumping all these trans files from the...

  • RE: Log Shipping Works, Copy says it''''s failed

    Changes made to the live db are being reflected in the copied db in roughly the timeframe we'd expect so yes I'm fairly sure the log shipping is working.  Plus...

Viewing 8 posts - 61 through 68 (of 68 total)