February 13, 2013 at 9:50 am
I can't find a section for this so I'll apologize in advance and put it here.
Does the ALTER DATABASE statement in SQL 2000 require any special conditions? ie., Single-User mode, Service Restart?
I'm just increasing the size of a database file with:
ALTER DATABASE MODIFY FILE (NAME=logifcalfilename SIZE=newsize
February 13, 2013 at 9:58 am
ALTER DATABASE MODIFY FILE ( NAME=logifcalfilename, SIZE=newsize )
No special considerations required.
If you don't have IFI set on, it may take a while, depending on how much you increased the size.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
February 13, 2013 at 9:59 am
That particular alter, no.
Other options in alter database may require single user mode, see BoL for details.
p.s. Please post SQL 2000 questions in the SQL 2000 forums in future. Thanks.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 13, 2013 at 10:21 am
Doh! I looked earlier and swore I couldn't find that SQL 2000 forum but at second glance, I've now located it..
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply