Thanks SSChampoin but where should my scripts fit in here? Please let me know. Any idea how exactly will it look with my scripts. I need that if possible.

Thanks you but Since I have no knowledge I need the exact statements with bcp if you can please..

That's what i am asking. I don't know the script. If you have any please share...

We already have the backup plan using DPM. This jobs that I have is just to refresh the test database nightly. So I am not at all worried about the...

let me explain in detail sir.

Step 1 : Server A takes database to a network location. (Let's say Server C //test-dql_1\backups\Prod.bak)

Step 2 : The do...

actually we don't need that backup copy because we do refresh every day. I just want to delete because i need free space at all times. So any idea how...

Right now the log files are around 100 MB, but still the log backups are big in size.

No the above query fails. any idea???

Thanks a lot all. It works great.

Hi,

I tried every possible ways but still cannot drop table.

any ideas???

I already restored but same issue.

When I run

DBCC CHECKDB (DB_name) WITH NO_INFOMSGS, ALL_ERRORMSGS

i get :

A severe error occurred on the current command. The results, if any, should be discarded.

When I try to rename,...

No there was no upgrade done. May be an un-expected Server shutdown.

Sorry my bad :

when running DBCC CHECKDB i get no errors

but when running the

DBCC CHECKDB (DB_name) WITH NO_INFOMSGS, ALL_ERRORMSGS get

A severe error occurred on the current command....