May 11, 2005 at 12:11 am
Good Day!
Is there a way to move the transaction log from another hard drive, we don't have any space from our current hard drive.
Thanks and hope you can help us.
May 11, 2005 at 2:04 am
Yes you can use sp_detach_db stored proc, move your transaction log file and use sp_attach_db sp to attach db. However it requires db downtime. Alternatively you can add new log file on different disk through ALTER DATABASE command. No db downtime but there's no need to have more than one log file, actually it can be a pain in some situations.
May 11, 2005 at 2:25 am
If it were me I'd be looking at detaching the DB and moving it to where you have more space, if existing space is so tight where it is then you'll also be suffering performance wise because of it (the fuller the disk the slower it works (without going into anything technical about it)).
As a general rule of thumb I always try to have at least 20% free space on any drive (normally 30%), if it gets down below that then it's time to look at upgrading your disks.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply