Quite frankly no, I had the following KBs that I always used for these occasions, however since they (management) brought up CLUSTERED for probably future data architecture optimization, i...

All

Just wanted to thank you all for your responses and let you know the issue is fixed by following measure taken.

I asked our SE team to reregister DTS.dll and it...

thanks jcampo and abhay,

jcampo, i manually backup full or transct the databases to the same path and it succeeds, it is only maintenance plan that fails

Abhay, since this is...

we were running on a cluster environment, i am trying to figure out if system engineers moved any service for sql from one node to the other last night, I...

You might want to run sp_who2 and see if there is a spid (a posible bulk insert) that is running too much of your resources and kill it.

hope that helps

Gift Peddie,

Thank you very much for the link, I changed autoshrink to off, but I will ask him to look over my shoulder while I run the version you...

Gail,

Thank you as usual, it is interesting that I had read your other posting and the same link you had sent before posting this thread. It so happened that they...

I forgot to add after researching on this same forum i had find out that maybe both RTrim and database_name_' + REPLACE(REPLACE(REPLACE(CONVERT(varchar,GETDATE(), 20),'-',''),':',''),' ','') + '.BAK' commands might...

Thank you for updating us. Do you think give us some incentive as step by step (your best practice that you took) the restart and reboot process for a...

Thank you so much, meanwhile I will try to curb and put keywords for error in subject line

Ellie

Yopu might want to add warehouse server or Bi database server. Normally these environements house the databases catered to Reports or dta warehouse.

***As previous posts said, it all depends on...

Steve,

Not to cast any shadow on the main post, can you give us some incentive on how to reboot cluster environment for SQL risk free? I understand there are conflict...

How about the following:

http://www.amazon.com/dp/0321447743?tag=infidmaxim-20&camp=14573&creat

http://www.amazon.com/Inside-Microsoft%C2%AE-SQL-Server-2005/dp/0735621969/ref=pd_bxgy_b_img_c/191-4037554-7951631

http://www.amazon.com/Inside-Microsoft-SQL-Server-2005/dp/0735621055/ref=pd_bxgy_b_img_b/191-4037554-7951631

Godd luck, I just ordered the first one and came in the mail yesterday, haven't gotten a chance to go through...

I have the similar situation where:

1- I backup DB from server A to server B (choose location as \\servername\directory$\backup folder\file path.bak)

2- On server B, I restore the Database from the...

Muhit has said it perfectly. Also if you have any other files in the folder that you want to cleanup, you can use "*" asterick instead of "bak" or "trn"...