I mean to say

I have one primary file group in that group move some table (10)s I have to move another file group

can any body please suggest me...

Hi Thank you for your reply

I had done mistake here.

am not create any schema that the reason it will give that error

1st create schema after then

in that one we...

Hi gail,

Thank you for your reply

Deleting T-log file it is not good right

we will shrink the file only

Is it possible to delete T-log file what happed ?

AS per my...

Hi Gila,

Thank you very much

I got every thing as same as before

Thank you very much for your help

really appriciate to other guys also ....

Regards

Kumar

Hi This is not Database issue

It is only server issue

Hi Gila,

In SQL SERVER 2000 We have maintain Two(2) Instances

1.'xxx-15878

2.'xxx-1345\xxx'

These are the two instances we have maintain

In the 2 nd instance in that EM in parameters we have...

Hi Gila,

Thanks your reply,

Two days back we have to start sql server 2000 in Enterprice manager in the parameters we have put -m.

But right know in EM is not connect...

Hi Thank you replly

in that query i not selecting the date

I am inserting date one new date with differenct table (employee,orders)

so plz suggest me it gives same error

Thanks

Hi Thank you for ur reply,

in that EMPID dont have primary key is it possible that one because it is very big database plz help me

Hi Gail

Thank u for reply

i had restore to local drive only i

but i am very new to do this work .net guy could please help me with step by step...

Hi

Thanks u for ur reply

Which of your backups are failing? T-Log fail

Where are the backups been written to? os error

What's the error message? network error 11745

How long have the backups...

Hi Broand,

I think no limit for table size in MS SQL SERVER 2005 could any body correct me incase i am wrong

MSDN mentioned DATA BASE max size is 524258...

yes i am running right db only

hi hall

'19:12:43 CDT 05/23/2007' this is event_date but it is in varchar datatype.

How can we convert varchar datatype to date time datatype any body plz give suggestion

hi friend

thank u for ur reply

that data type is 'evet_date'

now could u please give good suggestion how can i calulate the sum of them