It sounds like you might have an issue with the Litespeed install. Instead of trying to run the standard backup & restore commands, try using Litespeed's extended stored procedures. You...

Although if you move to SQL Server 2008 (or R2), you can use Change Data Capture to perform this type of change tracking without using triggers.

That's not a normal issue, but evidently it's happened before[/url]. It sounds like you must have some third party software involved with your backups, possibly interfering in the backup process...

yessen (6/28/2010)

---

Grant Fritchey (6/28/2010)

---

There a number[/url] of articles[/url] right here on SSC that can help you out. You just need to use the Search window over there in the upper...

I'd check out Craig Mullins book Database Administration. It's not so much a "how-to" manual but a "what kind of job are you looking for" manual. It's pretty technology agnostic...

Volume like this in sQL Server will require both hardware and careful database design, appropriate tsql, good indexes, proper maintenance... I'm with everyone else. You're probably better off hiring someone...

Yep, it ought to work just fine with 2005.

You should also check out Professional SQl Server 2008 Internals and Troubleshooting.

Not knowing the events you've defined,...

balasach82 (6/28/2010)

---

Thanks....Thanks....Thanks.

Thats a great way of explaining. Now I understand. Its complicated to get the query's count(which query ran how many times).

Still having one doubt.. that fileds with NULL values.....

The text data field shows the full query, including parameters passed. Take these two calls as an example:

EXEC spMyProc @parm1 = 42, @parm2 = 'Optional Parameter'

EXEC spMyProc @parm1 = 42

Now,...

Not to mention that the out of the box security settings are pretty tight:

Script exec is prohibited by default

ps1 is not associated with the shell

must provide a path to a...

There a number[/url] of articles[/url] right here on SSC that can help you out. You just need to use the Search window over there in the upper right to track...

Jeff Moden (6/27/2010)

---

Lynn Pettis (6/27/2010)

---

I will agree that there have been some bad calls, some made and some that should have. Over all, however, I think the officiating has...

GabyYYZ (6/25/2010)

---

Lynn Pettis (6/25/2010)

---

Steve Jones - Editor (6/25/2010)

---

PASS. No interest in flying 64 hours to ski for a couple days.

Send me pix, I'm happy to wait for Oct here. I...

Sounds basically accurate to me. The only addition I would make is to be careful about the shrink process. It can lead to other issues, including file fragmentation. If you...