as alluded to above those values are all configurable in the gui. Just go back and edit the logshipping properties and relate thresholds to your job frequencies.

If you don't restore...

jlennartz (4/27/2010)

---

If you reinstalled you Accounting Program it should have created empty databases like it was before you started using the accounting system. If that is the case...

The one you already have on server B is the version you want so use that one.

It is vital that the resource db files are in the same directory as...

This is just for fun but here goes anyway................

I wouldn't do it this way

Unless you have lots of linked servers (which won't decrypt anyway), user error massages, SPs in master,...

You are checking tempdb after the cause of the growth has been and gone. Tempdb stores TEMPORARY objects, so they have been created, used up 36Gb space, and been deleted...

If you have enterprise edition also take a look at snapshots with database mirroring.

you could do this with log shipping but you would have to have the space on the reporting server to store two weeks worth of log backups. Hard to say...

depends how much space you have for your transaction log.

Principal will continue to function but log will not be able to be backed up. so would eventually run out of...

pleasure. thanks for posting back.

sorry, forgot the code for the two views used in there.

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE VIEW [dbo].[all_session_usage]

AS

SELECT R1.session_id,

...

Set up a sQLAgent job to run the following SQL every 3-4 mins and output to a file. the file will grow by about 20MB an hour and will contain...

Nope, the good old SQL 2000 update sysjobs set originating_server = 'newservername' does not work in SQL2005 and up.:(

Have you tried editing the jobs to run under a different user

You...

Full or diffs no. But don't set up tran log backups through the maintenance plans , just use the log shipping log backups

First of all use the 2008 upgrade advisor to give you an idea of the DTS issues you might face.

when you install 2008 also install the Microsoft SQL Server 2005...

sorry just spotted you said SQL is installed as part of your application, must be SQL Express edition then. That does not come with SSMS but it can be downloaded...