INIT for overwirte.

NOINIT for append.

are u gettin this error using both sql logins and windows logins, it might be domain and authentication problems, check the event log it would help.

a read/write user has no such priv, to shut down the sql server u have to be like one of the sysadmin role, local adminstrator, domain admin..

i have found one noline but it requires to connect using DAC.

i need to check more but is there any difference between DAC and normal connection about things i can...

the link wont open.

have u search on the net for log recovery, u can extrace the transaction and apply them manauly,

if it is possible to do so.

so u want serverA to use like a folder in serverB.

if so u can create table in serverB, use the linkserver to but a command from serverA to serverB,

create a...

i hate this mause and cat games, is there any way to do this with out any one decryting this procedure?

restoring 20GB take no more than 20 minutes, the only time u need to shorten is Transferring the back file on the network.

thanks i will try this one, hope it do the job.

SSPI is related to kerberos authentication, u should check the trafice on ur router or ur firewall for any strange trafice.

if i have understand u this the way things r:

u have one full backup, and a Series of log backups and one of them is Corrupted.

if so then u cant...

so if i have this

select col1,col2 from table1,table2

where table1.col1*=table2.col2

and table1.col4=table2.col4

who can i fix this?

is there any diffirence what so ever? in any case.

i can think of two things:

open the port on th fire wall if any.

and make sure when connecting to sql server throw the Management Studio to choose this port, if...