You are correct in saying that no 1 is not possible, even if the db is pre configured, the foot print etc comes from the backup. You would need to...

Have a look at BOl and use the

SELECT DATENAME(month, getdate()) AS 'Month Name'

This retrurns the Name of the month, you might have to fine tune it to select a...

Helen,

In our situation, the job ran at night around 1 am would take any where from 1 - 2 hours to run. As long as we had a back up...

Hi Helen,

I have encountered this before and the quickest and easiest way was to set the db to simple mode run the job and then set it back to full...

Forgive me if I am a touch rusty on the Access side of things, but from memory Access opens a read only connection into SQL Server so you wont be...

OK...

1. with total 4GB RAM being configured to 3GB memory as SQL Server max server memory (after /3GB is being turned on and AWE DISABLED)

2. with total 8GB RAM being...

Hi,

To do a point in time recovery you need to apply all previous logs up until the time needed. The current log would restore you to the time that THAT...

Hi Blue,

OK, firstly AWE memory cannot be dynamically managed, like memory is normally managed in SQL Server. This means that SQL Server will automatically grab all the RAM it can...

Hi,

Firstly you need to set the  /PAE switch in the boot.ini as well as the /3GB:  /3GB /PAE

The /3GB switch is used to tell SQL Server to...

Like I said this is a 3rd party design and yes there are no PK's defined in all 720 tables and to make...

Yes it does, incorporate the full backup as part of the log shipping so restore that full backup as part of your log shipping job and then carry on with the...

Hi Ann,

I have found in the past with log shipping if you take a backup (full) the log file is trunctaed and then the next log to be applied to...

How long is a piece of string  ?

There are just to many factors to consider to answer a question like this correctly.

The opbvious...

The reason is that the MSSQLSERVER service is running under a separate set of NT credentials - all services are related to an NT account. It doesn't matter who YOU...

SS ENT Will run on Windows STD OR ENT Edition of 2003 so you wont need to upgrade your OS, even if one is ENT ED and the other is...