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 |
|
ac1998
Starting Member
2 Posts |
 Posted - 2007-02-28 : 10:30:58
|
| Beginneer with MSSQL. Backup done. mdf filezise > 27G, HDD size 32G. What steps to take to free up the hard disk? I require only to keep the current year transactions in the databases, previous year transactions backup into portable storage.thank |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-02-28 : 10:37:19
|
Are you backing up the database to the same drive or different drive ?You said previous year transactions had been backup into portable storage ? How is it done ? Are these transaction still in the current database ? Or has it been purged (deleted) from the database ?
KH |
 |
|
|
ac1998
Starting Member
2 Posts |
Posted - 2007-03-01 : 02:56:42
|
| Are you backing up the database to the same drive or different drive ? Yes, portable hard disk.You said previous year transactions had been backup into portable storage ? YesHow is it done ? Have to stopped the SQL service and do manual copy from the directory, due to hard disk fullAre these transaction still in the current database ? Or has it been purged (deleted) from the database ? Stored in the data directory in portable hard disk and deleted form the hard disk. However I am required to maintain data on current year in the database but backup the previous years into had disk. I have no idea howto.Its used to store application logs. |
|
|
|
|
|
|
Harddisk full