First I never back up to the network. Too unreliable and it will fail when you least expect it. Like the day that your database goes down. Backup locally, copy...

I did something similar years ago, but I used replication. Basically when something changed in source, I replicated the relevant table to the destination to staging tables. 3 (or however...

Not sure, but I'd move the DB to another server or drive and ensure it's not corrupt. There could be disk issues on the server and a complete copy to...

Thanks for the update, you had us stumped. I've only been able to change the OS time and have SQL lag by about 5-10sec at the max before it catches...

Thanks for the update and be aware that there are sometimes strange caching things that break for unknown reasons. Relinking would have been my suggestion if I were a little...

Alan,

What errors?

swekik, you need to run through the databases and query against sys.logins and use left joins to find those that aren't matched up. How many databases do you have?

I...

Getting a PMP isn't a bad idea. It gives you another skill you can potentially market. Plenty of people would like to hire a PM with development experience or vice...

What's the status of the corrupted DB? Can you connect to it and run a tail log backup?

Here, here, Barry. Anything requires time and sacrifice. My kids, my marriage, they all take work and time to continue to be something I can be proud of.

Manie,

Good luck and hope things improve.

And if anyone else wants to grab a shovel...

come on over. Always things to move around here. :w00t:

Interesting comments, and no complaints, Jeff. Just wondering. Usually I get a good diatribe if I've stoked your interest.

As I get older, I realize that no matter how much you...

Shrinking the transaction log regularly doesn't buy you time, it grows again as the two above mentioned.

The only time you shrink it is when some rare, one-time event (big load,...

Thanks for the update.

Your post makes no sense. Are you using SQL Server 2005 or MySQL? Please don't capitalize things that are not specific names.

You also need to ask a specific question. What...

Your exec returns a single value, not a result set.

You probably want to run this from SQLCMD or another client utility, not xp_cmdshell.