Oops Struts is definetly getting to me.

You'll need to just do a full restore from scratch. restart only works with tapes.

Dave

I might be wrong but I believe your only option is to finsh the restore you started.

I don't know if you can do this in EM but in query analyser...

It writes to each of the files in a round robin fashion so that data is evenly distributed accross each.

From Books Online:

As data is written to the filegroup, Microsoft® SQL...

I should also have noted that if you use multiple files do not rely on auto grow to grow your databases as it will only increase the size of...

As previously stated having a numerous files on a single Raid 5 array will likely make little difference to your performance but there is a more important consideration, in my...

Juanita

Thought this might be useful as well it lists the sizes of all the databses and the free space left in each

DECLARE @database sysname

DECLARE databases CURSOR FOR

SELECT CATALOG_NAME

FROM master.INFORMATION_SCHEMA.SCHEMATA

open databases

FETCH...

I would point you to this article

http://www.sqlservercentral.com/columnists/dpeterson/allabouttransactionspart2.asp

hth

Dave

It is possible to write some scripts to compare two databases in a relatively short period of time using the information_schema views and the system tables where necessary.

There are some...

There's loads of way to move databases between servers. I personally always use attach and detach where possible but the two links should provide some more info for you.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;314546

http://support.microsoft.com/default.aspx?scid=kb;EN-US;240867

Personally I would go down the c# route if you are going to keep using sql server especially with the clr and custom assemblies stuff coming into sql server 2005....

I had this problem once before and fixed it by restarting the rpc service on the machine.

It was fine after that.

Dave

I'm lazy so i've just copied from BOL but you want to do the following basically specify your restore operation with restart.

C. Restore a database using RESTART syntax

This example uses...

If the number of users exceeds the number of worker threads then sql server will start to pool the threads this can lead to contention among user processes requiring access...

You can using server network utility to hide a sql server on the network. click on tcp/ip then properties. I believe this could be why you are not seeing the...

I've had probelms with dates because visual studio seems on my computer at least to set the language of all report elements to US english so if you are not...