Hi,

I am actually looking at the scheduled task option - I think all the others require xpshell turned on, which is not best practice.

Thanks!

Actually I am trying to setup the backups to the local drive, then write a dos script that can copy this file to the network share, replacing an exisitng file.

Any...

Hi,

thanks for the sound advice!

I agree with the separate files, but I have some other people to convince. 🙂

It turned out that the network share that I was writing to...

Hi Gail,

thank you for your suggestion. It's a backup I'm doing by the way. Yes, we are thinking of network problems, and are exploring ways to prove this,...

Hi Pradeep!

I just saw your post when I sent mine.

That is EXACTLY what worked.

Thanks!

Hi Paul,

I found a fix that worked.

I created replication, deleted the configuration, and then I was able to shrink the LDF file!

Thanks again for pointing me in the right direction!

Hi Paul,

when I try that command, it says:

"Unable to execute procedure. The database is not published. Execute the procedure in a database that is published for replication."

Hi Paul,

I dont have replication configured. I chceked the Replication Monitor non-the-less, and there is nothing in there to monitor.

How can it be set in this mode without my...

Paul White (9/13/2009)

---

That's odd - you cannot take a log backup after a switch from FULL to SIMPLE recovery mode without taking a full database backup first. The full...

See http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/355e56e3-3d24-472f-903b-87618de3a1a6 for the solution.

Hi,

I used http://support.microsoft.com/kb/918992/ to solve part of the problem. It worked for creating the ID and keeping the password. However, it loses the Sever Roles and...