Thanks for the response, I also thought that the transaction log backup won't start until the full backup is done, but it did on my server. The full backup started...

I was running the job every hour (doing some testing) the filename only had the date in itand hence it was overwriting everything for that day, I fixed it, it...

Here is my xcopy string

@loc_file = @loc_folder_nm + '\' + @name + '_diff_' + CONVERT(NVARCHAR, GETDATE(), 112) + '.diff'

@nw_folder_nm = '\\web-server9\backup\mssql\dbserver\' + @name +'\diffbkp'

Set @copycmd = 'Move ' +...

Steve,

Thank you for your reply. I would ask for extra disk space too, but for now I have to make use of what is...

Marvin,

Thank you So much for the script, this is so helpful. I have one question, if you can provide some suggestion. I have to backup...

Lyn,

Thanks. So is there a way to test the transaction log backup of my script without affecting the 3rd party tool.

Thanks

Shri

Thanks

It is set up for full recovery, I am doing a transactional log backup every hour, but I did not know how take the monthly backup. Should I not set...

I tried to build a maintenance plan, but I am getting the following error when I do it. I using the maintenance plan wizard in SQL 2005. If anyone can...

Hello,

Can you please provide additional details about the Index Manager. I am trying to find the most effecient method to mnage indexes on our production server which...

Thanks

I think we will change the reindexing to once a week instead of once a day. This was on the test server where the transaction logs...

Ramesh,

Thanks for the script, how do I know when was the last time the indexes were rebuilt/reorganized. I am trying to come up with a...

yes it is just this one query, I am attaching the actual exec plan. When I run this in SSMS it is not so bad. but when I run it...

Yes all the files and logs are on the disk, how do I create a filegroup and move just a few tables to this file group. Also will I have...