How's this:

/*

Process initiated on 6/24/2009.

Desired "From Date" = 5/15/2008

Desired "To Date" = 5/15/2009

*/

declare @ProcessDate datetime;

set @ProcessDate = '2009-06-24'

select

dateadd(dd, 14,dateadd(yy, -1, dateadd(mm,datediff(mm,0,@ProcessDate) - 1,0))),

...

Have you read the articles that I asked you to read yet in my post above? If not, please go read them.

RBarryYoung (6/24/2009)

---

Gift, I think that you are right (and I think that's what Lynn is saying too). If someone PM's me about technical questions, I usually insist that they...

The other option is to create a job on the standby server and after moving the file across, use sp_start_job on the standby server to start the job that runs...

bear in a box (6/24/2009)

---

...it must be somewhere there within the 15 pages of posts.

the answer i was expecting from you would have been, "because the filter will take...

You may be having network latency issues when attempting to restore a large database over the network. You may need to copy the file to a local directory on...

First, what...

Start here[/url].

Then here[/url].

Any questions after that, ask right back here or in the discussion threads of the articles above.

The problem is that these queries may not be equivalent. What is the relationship between table1 and table2, is it a one to many relationship?

Some sample data for the...

I really don't think restoring a database over a linked server is a supported option. Pretty sure you need to be on the server where you are attempting the...

Sometimes that isn't possible. A few that I have helped went private because they could not provide the actual code on an open forum due to company restrictions. ...

IMHO, that reqiuires the participants to keep everything in the public threads. It is possible that some things may best be handled privately, but I would have to say...

karthik_sql (6/24/2009)

---

This is error i found fron SQL log

Database backed up. Database: OperationsManager, creation date(time): 2008/12/17(13:46:51), pages dumped: 637164, first LSN: 476:1227796:1, last LSN: 477:10953:1, number of dump devices: 1,...

Where did you get these error messages/alerts? If from a log, could you provide the actual message? Perhaps even a portion of the log before and after the...

One, by changing your recovery model to full, you may soon find you transaction log file taking all your disk space. You now also need to start running transaction...