I also used FORCE while restoring the master key. But in vain. Need help, Mike!!

RESTORE MASTER KEY FROM FILE = 'C:\Documents and Settings\v-ajohri\Database Backup\mk.dat'

DECRYPTION BY PASSWORD = 'Cheeku'

ENCRYPTION BY PASSWORD...

Thanks Mike C for this information but still I am not able to retrieve my data. I was able to take the backup of master key and certificate to the...

Thanks for a quick response Gila. No one noticed the certificate deletion for long enough till I tried to execute the select query. I shall visit the forum again tomorrow...

Yes the older one I have but that is really very old. I can make a new database with that. Now the question comes of copying the certificate and master...

I want to make this topic more interesting.

Take a scenario when the DB is online and transactions are open and some work is going on (insert, update, delete).

Now...

I tried following queries but did get nothing:

select * from log_shipping_monitor_alert

select * from log_shipping_monitor_error_detail

select * from log_shipping_monitor_history_detail

select * from log_shipping_monitor_primary

select * from log_shipping_monitor_secondary

select * from log_shipping_primaries

select * from log_shipping_primary_databases

select *...

Awesome Suresh!! Thanks

OOps then how to find the settings those where there in Yukon?

-LK

Yup

wrong date = simply NOT a date

-LK

Yes Dave. I agree.

The issue was a wrong date:

SELECT CAST('2011900' AS datetime) - This will fail..

-LK

I created one table with following values:

create table dateformatting

(

Joiningdate VARCHAR(100)

)

insert into dateformatting values('2/1/1900')

insert into dateformatting values('2/1/1900 0:00')

insert into dateformatting values('2011900')

insert into dateformatting values('02011900 00:00:00')

insert into dateformatting values('1/2/1900')

insert into dateformatting values('1/2/1900...

The issue is that the object level recovery is not supported in sql 2008. Litespeed team is working on this and will get this done within next 3-4 months.

-Lk

Can anyone assist me here?

-LK

AWE enabled (64-bit system)?? AWE, /PAE, 3GB and /USERVA are only for 32 bit. Correct me if I am wrong.

-LK

use CONVER(VARCHAR,fieldname,109)

-lk