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 |
|
chih
Posting Yak Master
154 Posts |
 Posted - 2007-07-13 : 10:25:47
|
| Hi everyone,Due to running out of disk space and reducing I/O contention, I plan to seperate data files and log files to different disk arrays. My plan is to - detach all databases- copy log files to another disk- attach all databasesThe total size of log files is about 60GB. It becomes a problem becasue it spend too much time passing files. To reduce down time, is there any way I can do?Can I just create new log files and remove the current files by using sql management studio?any other suggestions? Thanks in advance |
|
|
pootle_flump
1064 Posts |
Posted - 2007-07-13 : 18:05:53
|
| What size are the databases? Is your backup routine set to full and you are not backing up your logs?It is a good idea to have logs and data on different arrays but the size of those logs is possibly a concern.Ah - just noticed you say total size of all logs. How many logs? what sort of size are they? |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-13 : 18:11:36
|
| You can create empty log files in new location. Backup db before detaching. |
|
|
|
chih
Posting Yak Master
154 Posts |
Posted - 2007-07-14 : 20:52:59
|
I have 23 user databases and one log file per database. I set full for routine backup. The total size is about 60GB (physical disk size). I didn't shrink them.quote:
Originally posted by pootle_flump
What size are the databases? Is your backup routine set to full and you are not backing up your logs?It is a good idea to have logs and data on different arrays but the size of those logs is possibly a concern.Ah - just noticed you say total size of all logs. How many logs? what sort of size are they?
|
|
|
|
chih
Posting Yak Master
154 Posts |
Posted - 2007-07-14 : 20:55:20
|
If I create a new log file, Can I remove the existing one? Some forums say it cannot be done but I have not tested it yet. I will test it.quote:
Originally posted by rmiao
You can create empty log files in new location. Backup db before detaching.
|
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-07-14 : 23:13:33
|
| You can set new default log file location in server, backup the db, detach it, then reattach with sp_attach_single_file_db. |
|
|
|
|
|
|
Move log file to another physical disk