As the question specificaly mentioned SQL Server 2005, you could queue up a COPY_ONLY backup to start when the scheduled backup finished. This copy_only backup would not distrupt the...

Hopefully you included the norecovery option in the restore of the full backup. if not, you will have to redo the restore of the full backup.

How many transaction log...

Just one last question, based on the sample data provided, what is your expected output?

😎

Lubo Petrov (4/7/2008)

---

properties of bak file created March 26 at 12:00:20 AM Modified at 12:01:10 AM

properties of trn file created March 26 at 12:00:22 AM Modified at 12:01:27 AM

I'm want...

have you tried this:

select

...

From what I can tell, then the only option short of sysadmin is the dbcreator fixed server role. This would allow them to create new databases, but also to...

Looks like you'd have to assign them to db_owner in those databases that you want them to have backup and restore rights. If you only want to give the...

I agree with with Matt. We just had an on-site instructor out here for a week, and we had him totally skip the Notifications part of the class just...

GSquared (4/7/2008)

---

Since you can't change the trigger, the only thing I can I can think of is breaking up the update code into batches.

if (select Col1 from dbo.Table where id...

We use an Execute Process Task to zip a set of txt files before they are transferred to a MSP. The attached document shows how we have setup the...

Jack Corbett (4/7/2008)

---

Accroding to Wikipedia:

ASP - Active Server Pages

Yes it means that there...

Okay, I'm old and really tired of all the TLA's everyone throws around under the assumtion that we all remember what they are (for example what is ASP, and there...

Sounds like a scheduled job to me. I'd encapsulate the process in a stored proc, and then execute the proc in a scheduled job.

😎

Earlier today my BufferHitCacheRation was down to an average 75 for a good 30 minutes, and the alert never fired.

We did find the solution to our slow PO performance issue;...

I'd actually have to agree that all 4 are correct. I left out 10^24 as I didn't realize that 10^24 = 1000^8. I based my answer on the...