Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
antony_dba
Starting Member
26 Posts |
 Posted - 2010-11-30 : 01:34:54
|
| Please suggest how to reduce the size of database.whether by reducing the amount of storing the transaction log ,it's able to reduce the size of database.kris |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-30 : 04:57:04
|
| You will have at least one transaction log file probably with extension .ldf and a data file with extension .mdf.You can reduce either by a shrink - right click on the database, tasks, shrink.First you have to release space though. Is the log or the data file the issue.If the log which recovery model does your database use and do you have log backups?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
antony_dba
Starting Member
26 Posts |
Posted - 2010-11-30 : 05:05:26
|
| whether shrinking the database it's allow the database to reduce the size of the databasekris |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-11-30 : 05:12:39
|
| No idea what that means.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
size reduction