SELECT

DATABASE_NAME,[TYPE],BACKUP_FINISH_DATE,

(BACKUP_SIZE/1024/1024) SIZE_MB,PHYSICAL_DEVICE_NAME,

[USER_NAME]

FROM MSDB.DBO.BACKUPSET A JOIN MSDB.DBO.BACKUPMEDIAFAMILY B

ON(A.MEDIA_SET_ID=B.MEDIA_SET_ID)...

pawantanwar87 (4/9/2010)

---

by mistake my new database have been replaced by old backup of same data base.how to get backup of my new database....i don't have new database backup.....in this case...

I agree with Brain.

Do you have all latest backups?(full,diff&logs)

No, 50/50

Please Start new thread.

Glad to help you.

Results from google

------:-)

http://www.google.co.in/#hl=en&ei=mtKxS_idAYL48AbvnbjHAQ&sa=X&oi=spell&resnum=0&ct=result&cd=1&ved=0CAUQBSgA&q=DR+types+sql+server&spell=1&fp=6e67f0911d014d29

ferdin448 (3/30/2010)

---

Dear All,

I uses this

declare @str varchar(500)

set @str='bcp dbo.EMTemp in E:\CSVConversion\EMTest1.csv -n -T -S info71\SQLEXPRESS'

print @str

exec master..xp_cmdshell @str

but Received this error

SQLState = 37000, NativeError = 4060

Error = [Microsoft][SQL Native...

No, The OP want just 20 tables.

Result from google.

-----:-)

http://www.google.co.in/#hl=en&q=transfer+data+from+table+to+another+table%2Bsql+server+2008&meta=&aq=f&aqi=&aql=&oq=&gs_rfai=&fp=6e67f0911d014d29

sku370870 (3/29/2010)

---

I have 3 databases used for development, user acceptance testing and live.

The database stores the data used by 4 different departments in an organisation. One of the departments have...

Question is not...

Is it Interview question ?

Go google/BOL 🙂

Nitin Gupta - SQL DBA (3/26/2010)

---

Might be it's not work in this case but I have done this previously as I got my database is in recovery mode. I just...