I am also confused too..esp.when it comes to the SQL Server licenses...

Can I use Developer Edition in any environment other than PROD?

Not quite clear about what Status you are interested in.

Maybe you could try these:

ON YOUR Secondary Server:

--Get the latest copy and restore job status--

select * from(

select top 6 j.name...

Thanks for the reply. I will test those applications on our test box and if I got issue, I will bother you again. 🙂

Actually, if 64bit SQL server not works...

Open a profiler on your Database server, and then try to go to your website to make order, and see whether your Order will hit your database.

If nothing goes...

Think about logshipping?

Set them up and only SHIP LOG once a month. the restore will be only restoring your updates, not the whole database, this will save a lot...

I was gonna ask same question as Lynn had.

How are the PROD DBs being used?

Just read-only?

When you click Backup, choose Disk, ADD... then click that [...], it will open up the whole directory of your computer and you can choose the desired directory from there....

Meredith Ryan (3/27/2009)

---

As far as root cause analysis of my logshipping issues there seem to be a few. One issue I have is with the shared folder setup that...

Mohit, You are right.

I found that the user account I was testing with is part of the LOCAL Admin on the reporting server. Hence, no matter what role I was...

Disable all the logshipping jobs:

Manually Kick off the Logshipping-backup log job onyour primary server;

when it is finished, manually start the logshipping copy job;

then start the restore job...

Maybe I misread, I thought you...

Run this on the server, and see what parameters the procedure SP_SEND_DBMAIL is using:

USE MSDB

GO

SP_HELPTEXT SP_SEND_DBMAIL

GO

Did you try to send a Test DBmail:

Management-->>Database mail--->>right click, send Test-Email...

See what will happen.

Brilliant.

I would start with the profiler.

Find out when appliaction's hitting the road, which Major proceures are being called and which major tables are being queried.

Then Sp_helptext those major...