Thanks Gail. I think i will have to go with your 1st option, here is what i think please correct me if i understood wrong

1. My database is in simple...

is it possible to do file group restore keeping the database in "simple" recovery model? we always keep the databases in simple mode as the data is not changing on...

I am getting the following error because becaseu tempdb size is more than the actual drive space and i am unable to start the server though i can start using...

I have a server REVSQL with 2 clusters (REVSQL1 and REVSQL2) on win 2012. I need to install sql server 2012 on this now, should i be naming the instance...

I could not start the sql server after enabling this , why any help?

i could not start the server in safe mode too, how do i disable the c2 auditing which i already enabled.

Execute to disable C2 Audit mode

sp_configure ‘c2 audit mode’,0

can you please give me an example how to do that?

If its a permissions issue how could that loop make half way through hitting the same tables and database/server?

just so you know my loop iterates almote 50k times, do you...

I just confirmed that its a RAMSAN drives and though the 5TB i have is memory not disk.

when you say proportional manner do i have to restrict each file to certain size and then when total size uses more than max of all files then the query...

but i am planning to put them on a single SSD drive which i asusme would be 8 files each of 100gb. so i think any file would be used...

I see 40 CPU's (2 nodes) when i check properties of sql server under "Processors". I think creating 40 tempdbdata files may be too much.

I do have 5 TB of...

I have the same problem and mystery jumbo may be right but i can not even check sp_who2 to find who has a open connection, what to do?

i have more than 400 dbs so i cant use spmsforeachdb as it wonts display everything in the result, is there a way i can just get the list of...

would there be any difference in SQL Agent 2005 and 2000?