Perry Whittle (11/26/2012)

---

The LSNs and hence restore points will be completely different between databases, it would make sense for you to read up a little on how database mirroring works...

we dont require any info from your side , just follow what John Mitchell-245523 explained above. and take help from any person...

means both servers are not same from data (even sql objects too ) perspective

Rohit...

SSSsil174 (11/26/2012)

---

I want the rollup of D1, D2 etc for each name.

Example: If the result set like the below..

Clientid TagId NameD1D2D3D4D5

147American100050030000

148Hispanic0001000200

147American100050030000

148Hispanic0001000200

I want the result set like the following..

Clientid TagId NameD1D2D3D4D5

147American100050030000

147American100050030000

147...

sanath.kumar.kura (11/21/2012)

---

Each data file is 650 Gb but out of which data allocated is 325Gb and 325GB free space. So totally database size is 875GB but free space is approximately...

see these links

http://wyerarch.blogspot.in/2010/11/sql-server-could-not-spawn-fruncm.html

http://blogs.msdn.com/b/sql_protocols/archive/2006/01/10/511330.aspx

kiasystemsoft (11/26/2012)

---

Sorry

I can not speek English well

I have two fields

The account is a person

In each row I have a previous account

It may be that the debtor or creditor

If you...

sqlquery-101401 (11/25/2012)

---

delete from #ExistingBackups

where

(Name not like '%master%' and Name not like '%model%' and Name not like '%msdb%') or

(ISNUMERIC(Right(SUBSTRING(name,1,charindex('.',name)-1),8))=0) or...

have you checked with Sp_who2 and sp_lock that which seesions are got blocked for that particular database ?

can you explain a bit ? i am not clear as if you are adding or subtracting columns value :hehe:

shohelr2003 (11/23/2012)

---

Now for some reason I wanna restore database to my principal from another databse.

Will it cause any inconsistency in mirror databse? Or may I need restore database and log...

what would be that decent valure ? in...

what other alternative we can take here instead of "!= "

thanks perry but my question was little different , i want a...