please try and make your posts a little more readable , otherwise it takes us twice as long

as far as i can make out this is what you want

what you...

i also thought i might add - i've seen the strategy of taking SAN snapshots before. the particular client of ours was keeping a record of the data churn so...

i don't beleive this is possible at all

to restore a database to point in time (or alternatly restoring t-logs while in full recovery mode) the database needs to be in...

http://books.google.co.uk/books?id=fx4JM99vKZ8C&pg=PA53&lpg=PA53&dq=state_desc:+DISCONNECTED_INBOUND&source=bl&ots=IpRTThulJv&sig=1N3DXono1r6jUCnNMQIPrFbPZ6s&hl=en&sa=X&ei=tWC2T6zYM8TbsgbD-6GXCA&ved=0CFMQ6AEwBQ#v=onepage&q=state_desc%3A%20DISCONNECTED_INBOUND&f=false

oh - also

the state of those conversations

state_desc: DISCONNECTED_INBOUND

i think (and i may be incorrect) that the initiator of the conversation is not closing the conversation - which is...

bingo - here is your problem

your service broker conversations are not being closed, this puts memory pressure on and forcessql to dump these to tempdb - sql does not know...

i...

i really would avoid approach 2 - this might make querying easier for now, but someone will change the reports later as "new requirements are added" and maybe this table...

HowardW (5/18/2012)

---

AlAndrew (5/18/2012)

---

michael vessey (5/18/2012)

---

i think this is correct

UPDATE a

SET a.Age = b.age

from table_1 a left outer join (

SELECT userid,age from table_2 x where recdate=(select MAX(recdate) from table_2 where...

yes - sorry - a typo on my part

http://www.brentozar.com/sql-server-training-videos/

brent ozar does some excellent video podcasts - http://www.brentozar.com (i think)

acorrei1 (5/18/2012)

---

Trying to do a DR test. The file did exist but got deleted. I'm trying to recreate it.

GO

ALTER DATABASE tempdb

ADD FILE

(

NAME = tempdb_data_04,

FILENAME = 'x:\xxx\xxxx.ndf',

SIZE = 2MB,

FILEGROWTH...

if @sync_type initialize from backup is not the correct one, then it will be @sync_type='none'

see books on line

http://msdn.microsoft.com/en-us/library/ms181702.aspx

hiren.patel 911 (5/18/2012)

---

michael vessey (5/18/2012)

---

hiren

i have done this before - there is an option that you can use, but it depends on how much of the data on your POS...