http://www.veloci-group.com/remotebackup.html (1/15/2010)

---

But if I do the same thing, but now there's a second full backup (to NAS) in between 2 log backups...... You say to me that it would...

You mean test how much it will help without creating it? No.

Create the index on a test system, test the queries, see if the new index improves them, if so...

Randolph Potter (1/15/2010)

---

One thing I've been begging Microsoft for, is country-specific pricing. I'm pretty sure this is difficult to manage to avoid abuse, but it would make it more affordable,...

Jeffrey Williams-493691 (1/14/2010)

---

Gail - the concern I would have here is that the OP is looking at automating the process. Once automated, everyone forgets that it is there -...

Is the state 'recovering'? (check sys.databases)

If so, look in the error log, there'll be lots of messages saying that the database is recovering and how much longer is estimated. All...

Yes.

http://www.veloci-group.com/remotebackup.html (1/15/2010)

---

We have remotebackup of the SQL server. We can't restore from LOG backup if...

The 'standard SQL log file' is the error log.

Visible in SSMS, gives details on login failures, startup messages, etc. That...

Which log files? Error log?

Are you using differential backups? If not, there's no real reason to take copy-only backups.

No, it is used (when...

Troy G-471787 (1/14/2010)

---

If you truly have the need to pass in the "boundaries" that way then your best bet is to pass them both in individually and construct dynamic SQL...

Randy Anthony (1/14/2010)

---

Ok, so setting this:

If @AuditYear = 1 Set @AuditQuesTypeParameter = '1 And 4'

Else

Set @AuditQuesTypeParameter = '13 And 16'

and expecting this:

And tblAuditQuesLkup.AuditQuesType BETWEEN @AuditQuesTypeParameter...

Then your order by needs to be on a column that stores the date...

And the definition of the clustered index (data types of the key columns)?