i ran DTA against the query and it did create a non-clustered index with "INCLUDE" on all columns. What does this mean?

steve-893342 (9/2/2010)

---

I think it just needs 3 quotes either side of @db_name

select @SQLString ='select ''' + @db_name + ''' as databse,type_desc,create_date,modify_date from [' + @db_name + '].sys.procedures

where create_date > @create_date

order...

yup i figured that out by few tests..thanks

Jeffrey Williams-493691 (9/4/2010)

---

Again, a differential is based upon the previous full backup taken prior to the differential. Once you performed the snapshot backup (which is a full backup), then...

Jeffrey Williams-493691 (9/4/2010)

---

Again, a differential is based upon the previous full backup taken prior to the differential. Once you performed the snapshot backup (which is a full backup), then...

thanks a Ton. Steve that is what exactly happened, we didn't knew that snapshots were happening which broke our differential backups. Thanks

Ok. But the snapshot backup is just 5 mb. If you look at the order which i have mentioned in the first post based on that how can i restore....

thanks Steve and Jeff. It makes sense now. I looked at many different microsoft articel but i couldn't find the exact syntax to take a snapshot backup. Do you know...

ok,..seems like i didn't phrase the question right. There is full backup taken on every sunday and daily differential backups and log backups every two hours. Now my question is...

there is no error, what values should we compare to see if the backups are in order or not. For obvious reasons i cant post the results. thanks

Nevyn (9/1/2010)

---

Try:

declare @db_name nvarchar(max),@SQLString nvarchar(max)

declare @create_date datetime

set @db_name='TestDB'

set @create_date = '2009-08-20'

--select @SQLString ='select @db_name'

--exec (@SQLString)

select @db_name

select @SQLString ='select ' + @db_name + ' as databse,type_desc,create_date,modify_date from [' + @db_name +...

Update, sorry was looking at the wrong directory. I do see the log files but i do not see an entry for when the server was stopped.

This is generic error in SSAS 2005 saying evaluation has expired. This is fixed in SSAS 2008.

thanks everyone. This was for a dev environment, but i was just trying get thoughts from other DBA's about VM.

thanks