Viewing 7 posts - 1 through 7 (of 7 total)
Try the 32-bit version of the Import Export Data Wizard.
February 1, 2011 at 6:25 pm
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...
February 1, 2011 at 6:19 pm
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...
January 19, 2011 at 11:28 pm
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...
January 13, 2011 at 6:46 pm
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...
January 13, 2011 at 6:16 pm
You can also consider Change Tracking or Change Data Capture. Both functionalities come with SQL 2008.
January 7, 2011 at 1:07 am
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...
October 20, 2010 at 8:06 pm
Viewing 7 posts - 1 through 7 (of 7 total)