It's trivial to get the file size without free space.

You do need the free space to plan for...

Just by curiosity,

why do you track backup size instead of data file size?

Lowell (4/11/2011)

---

add the 6x for db and 17x for backups, and I'm at 460 gig to provide for a db that's 2 gig today. I'd say that's way more space...

For the tablock hint, you can use the -h option in bcp.exe, so you get something like this:

bcp "dw_load.dbo.DW_Fleet_Load_Progress" in f:\DW_Fleet_Load_Progress.dat -T -c -q /b 25000 -h "TABLOCK"

If rebuilding the...

If you keep the clustered index (to avoid having to rebuild it later), try setting a batchsize (like 10000) in your bcp in, to keep your log from growing too...

Yes it's rebuilding all the non-clutered indexes.

Rebuilding the indexes by hand would remove the logging (it would only log which pages have been allocated but that doesn't take much room).

You could try different things:

Remove all indexes beside clustered and on pos-date

Try smaller batches (100, 1000, 5000, 10000) and see which is fastest (on some system i had much better...

You need to be local admin to start the setup of sql server.

It won't let you go further without it.

How do these databases gets loaded with data?

If it complains about a full backup missing then the database might have been switched to simple recovery and then back to full...

Hot standby is a server that will automaticaly failover if the primary server fails. You can get this using synchronous mirroring + witness (not sure if a cluster can be...

Svs2010 (2/8/2011)

---

@Oliiii - I will start analyzing these factors.

so far we are manually analyzing these factors using SQL profiler, do you suggest any other tool to perform it automatically and...

The common problem on shared server are other applications eating all the CPU or the disks.

You need to monitor your current sql server and keep the data for reporting for...

First of all, 60GB is not a VLDB, it's a regular DB for today's server.

The easiest way to make this DB available on another server is a simple backup/restore.

With a...

It might just be quicker to scrap the cluster and reinstall it (make sure you don't erase all your db files).

Could you post some...