Some times I have been seen for couple of my servers, But wanted to make sure that you have been changed the configued job.

That's perfact, I will do the same. If you can not able to do that then probably Last backup is the best one.

Why can not you use the Backup and Restore option. It's not a best practice that you can move the mdf file over the network to the new server.

Backup and...

Please read this and you should be ready..

http://support.microsoft.com/kb/902388

Do with the same, as will do in Logshipping.

Yes, It is possible and Thanks JWOL.

toparsi (6/19/2008)

---

Thanks a tonn guys for all the help and the replies. I tried using it this way

This was the step which I created and gave type as cmdexec.

Copy...

I Agree with Gordon. with init it shows you the %age how much got restored on the DB. Make sure with your log file data file should not be on...

I would suggest it's depend on the organization and...

Why can't you go with Robo copy or network copy thru \\servername\drive $\path.

Or else use windows scheduler to use the copy over the network.

You can use Dos command as well....

Correct Erin, You Can use Cleanup task in SQL 2005. Make sure that .bak, .dif and .trn all should be seprate and schedule as the timeframe you required. 🙂

Still I will say this should comes under GLBA act. And organization will assign some kind of legal employee and that server should be under monitor. So each and every...

Alert will not give any pain to SQL engine, it means no...

Try to do this exercise...

Fix/WorkAround/Solution:

1) Use WITH REPLACE while using the RESTORE command.

2) Delete the older database which is conflicting and restore again using RESTORE command.

I understand my solution...

I am usingthe same and in the log it shows verfied backup successfully.

try to setup on test server or a test job with the same option. I did it now...