Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: Import and Export Data (64-bit)

    Try the 32-bit version of the Import Export Data Wizard.

  • RE: MDW Database bloats; Purge job runs continuously

    Have you checked what table is using most of the space? I bet is snapshots.notable_query_plan.

    I had the same issue in the past with 2008 R1, and all I could do...

  • RE: Purging Old Tables

    You can rename the tables before actually dropping them. For example "DELETED20112010_TableName". If nothing breaks after X period of time you consider safe, you can delete the table. If something...

  • RE: sql 2005 and sql 2008 instances

    I'm afraid I don't. Setting the compatibility mode to 90 always worked for me when migrating databases. I just backed the DBs up in 2005, migrated the logins, restored the...

  • RE: sql 2005 and sql 2008 instances

    Do you really require two different versions of SQL Server in the same cluster?

    What if you install only 2008 and, if you have applications that won't support it, then...

  • RE: SQL Server Audit

    You can also consider Change Tracking or Change Data Capture. Both functionalities come with SQL 2008.

  • RE: transactions during full backup

    A full backup will include as much information as possible at the time it finishes. The full backup takes into account the logs, and thus leave the DB in a...

Viewing 7 posts - 1 through 7 (of 7 total)