marvin51796
MIS
Is it ok to do an alter database to add more space if people are logged in or should you have everyone logout first??
THnxs for any advance on this..
THnxs for any advance on this..
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
alter database live 1
- Thread starter marvin51796
- Start date
- Status
-
1
- #2
It's perfectly okay to do an ALTER DATABASE while the system is in use. All it will do is slow the responsiveness of the system somewhat during the time the disk space is being swept (Sybase writes nulls to each byte on the disk when new space is added to a database). However, this is no more intrusive than any other user doing a long query that requires a lot of IO.
Having the responsiveness go down a bit is a lot less disruptive than kicking everyone off and there's no advantage in terms of reliability or soundness of practice in booting off the users before expanding a DB.
HTH, J M Craig
Alpha-G Consulting, LLC
nsjmcraig@netscape.net
Having the responsiveness go down a bit is a lot less disruptive than kicking everyone off and there's no advantage in terms of reliability or soundness of practice in booting off the users before expanding a DB.
HTH, J M Craig
Alpha-G Consulting, LLC
nsjmcraig@netscape.net
- Status
Similar threads
- Locked
- Question