Can a Database expansion of let's say 1GB be done while users are accessing the database?

Also, Can the add database file to the primary filegroup be done while users are...

Thank you for the response.

I was only going to download the public rollup.

Thank you for the reply.

Thanks, that's what I did for now.

I do not know how to pull out indexes and put them on a new filegroup.

Re: Backups. Once a file is not used anymore it can be reindexed one...

OK, the current LUN is LUN D and has a primary database file of 400GB.

We created a new LUN, LUN F with 800GB free space. (RAID5 - not the...

So you are suggesting that we create 4x200GB files in the SAN LUN that the systems group created. How about 2x400GB?

The LUN is 800GB.

Great, thanks, there are no clustered indexes on the table.

That's the scary part, we did run updateusage!!!

I have DBArtisan, but not the current version that supports 2005. Since MSSQL 2005 does not have it canned, I guess I have to use another Product! Thanks,

Sorry about the double posting!

Ok I'll try 5% on a 250Gb database.

We are using Standard Edition SQL 2000 and we have SP3a. We are not using AWE, Analysis svc, or reporting svc or any other add ons. If we...

They have different userID's but they also know the WIN Administrator account.

I see a lot of these messages: The WinHTTP Web Proxy Auto-Discovery Service service entered the