Actually, I think you should give it a try first. If you run into problems, post what you have tried and we'll see what we can do to help...

Glad you were able to resolve your issue and posted what you did to solve it as well. Looks like it will benefit others. 🙂

So, is everyone at PASS having fun? Wish I could be there!!

PiMané (10/31/2009)

---

damn.. forgot bout that :S

Thanks...

So, if there's no need to point in time restore, the best for us is to have single mode, with full backups and diff backups...

There have been several discussions on SSC regarding this. You may want to try searching this site for ORM, NHibernate, Hibernate.

Actually, using SQL Server 2005, this may be the better choice as it keeps the data with the appropriate rows.

create table #MyTest (

[name] char(1),

...

The transaction log is the transaction log. It doesn't matter if you have one filegroup for the data or 100 filegroups for the data. There aren't separate transaction...

Can't speak to using filegroup backups, I have never used them personally.

Regarding shrinking the t-logs after t-log backups, NO. It would simply have to grow again as transactions are...

PiMané (10/30/2009)

---

basically what you're saying is that if I NEVER make a transaction log, cause I don't need for any reason and have full mode to make differential backups, the...

Full and Differential backups do not truncate the transaction log. This is only done by transaction log backups. Please note that truncating the transaction log is NOT the...

something like this:

declare @StartDate datetime,

@EndDate datetime;

set @StartDate = '2009-10-14';

set @EndDate = '2009-10-21';

select

*

from

where time between...

jude-32296 (10/30/2009)

---

When I transferred my logins from one Sql 2005 to another, I failed to change a setting in the script & now all my logins have "Enforce Password Policy"...

frontpedal (10/30/2009)

---

Hi everyone,

My database table has a time field called [time], Data Type of "Numeric" length of "9" with a Precision of "14" a Scale of "0".

The query below...

jcrawf02 (10/30/2009)

---

WayneS (10/29/2009)

---

A former boss of mine used to say... if 24 hrs a day isn't enough,...

Unfortunately, since you haven't provided the DDL for the tables, sample data in a readily consummbale format, or expected results based on the sample data, this is all I could...