Hi rajesh ,

wait for rollback completion because from how long time that spid is using that much time will take for rollback action.

Thanks,

subahan.

Hi ,

The mdf is offline and please confirm ur database is in suspect mode(means database is not responding )

Hi all,

what is RAM size(physical memory) and check currently how much physical memory is taking for running

sql server ( use task...

Hi george sibbald ,

thanks for ur reply and i am new for sql server and i want know abt what i asked .

please give me...

Hi All,

how we can find one table is located in mdf file or ndf file ...

Thanks in advance.

Hi All,

How to move perticuler table from mdf to ndf ..

Thanks,

subahan munthamadugu.

backup log TEST2LOCATION to disk ='F:\backup\log.trn' with norecovery

Hi all,

backup with .... norecovery option

backup log TEST2LOCATION to disk ='F:\backup\log.trn' with norecovery but it is not possible to take full backup with norecovery option

Thanks,

subahan.M

Thanks for your reply

Hi all,

please give command for "backup with norecovery" option.

Hi,

let me know which sql server version it is and up to 2008 version it is not possible to take backup into external Harddisk why...

Hi,

the databases are in "simple" recovery model then no need to truncate the log file by using some other job . why because in simple recovery model ,once the...

Hi,

in your environment having test servers ? then create one linked server for that 2005 server(express edition) and create job for taking backup in your test servers.

note: in backup...

for your acount no permission to write the data on the network folder

possible soluation : give permissions on network folder for your acount

Hi ,

let me know you are taking backup to local disk or network path . i guess you are taking backup to network path and backup...