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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-01-28 : 12:17:13
|
| Scott writes "We currently have a production database that is installed on a machine with a 5 disk RAID5 array for the data and a 2 disk mirrored set for the transaction logs, however; When I created the database I placed the primary log file on the RAID5 array and a secondary file on the mirrored set. After seeing my mistake (much later) I limited the primary file's size to 1M and created a secondary log file on the mirrored set so it would get the bulk of activity. How can I move the primary log file to the mirrored set without major work? i.e., droping the database, scripting a new one, bcping data in and out, etc.? This database is used 24/7 and any downtime is significant. This database is on SQL 7.0_SP2/NT Server 4.0_SP6." |
|
|
|
|
|
Moving the Transaction Log Primary File Location