I have one question regarding SQL 2005 Database .mdf.
I have one database and its more than 290 GB. I need cut this Database and I don’t know how.
For example, cut this by Date, take offline in a separate part as 2011-12-31 or older
Asked
Active
Viewed 50 times
0
Peter G.
- 14,786
- 7
- 57
- 75
user1901198
- 1
- 1
-
2what do you mean with cut by Date? – luchosrock Dec 13 '12 at 14:18
-
In SSMS object explorer, right click the database and choose Tasks -> Shrink -> Database. Now repeat for Files, does that do anything? – twoleggedhorse Dec 13 '12 at 14:20
-
If you right click the database and go to properties -> Options, what is the recovery model? – twoleggedhorse Dec 13 '12 at 14:22
1 Answers
0
Are you sure the 290G is not mostly a huge transaction file that needs to be backed up or truncated?
How you choose to prune this database is entirely up to you. You could do it be a date column in your tables, if that is appropriate. It really depends on the type of data being stored in your tables.
Randy Minder
- 47,200
- 49
- 204
- 358