What is the best way for encrypt ?

as the gentel men said above really with normal encrypt option stored procedure is not secure enough?

Hi,

Sorry by mistake its twice.

Thanks

Raj

kiranjanjanam (11/10/2010)

---

Thanks guys for your replies...

After seeing the posts, I think its the log backups taken out of log shipping that is breaking the log shipping.

i will communicate with the...

Hi,

So as per converstaion the I am thinking Diffrential backup not make any impact on Log shipping.

Am I right ?

I have implemented logshipping on a VLS DB and...

arr.nagaraj (11/9/2010)

---

Hi Simon,

Thanks for such a nice explaination. I have some diffrent case hope you will give suggestion for this.

I did logShipping for a large database now the file size...

Hi Simon,

Thanks for such a nice...

Hi ,

I find link http://www.bigresource.com/Tracker/Track-ms_sql-RHOaQHat/

but when i went deep i found generally machine name & SQL Server Instance name are same.

but in...

Hi

i have same problem

"The specified @server_name ('WIN-xxx) does not exist.

SQL Server Management Studio could not save the configuration of 192.168.1.

119 as a Secondary. (Microsoft SQL Server Management Studio)"

i...

Hi,

I run the job manually for log shipping instead of scheduler.

Now re creating and applying basic hope it will resolve my confusion too.

mean while if you people have some...

Yes smith,

i am also interested in stand by mode.

but just need to figure out if there is something which norecovery mode have for log shipping but stand by mode not.

Thanks

Rajat

george sibbald (8/18/2010)

---

its available because its something you might have to do if space is a problem. there is a command to drop a database also, doesn't mean you should...

Hi Experts,

What ever you people said will be fine but only one question

"Why we should not shrink Log file while its given by mircorosoft ?"

What are the drawbacks ?

by Property of file ("right clicking") LDF & .trn

Hi Thanks Jeffery,

I just want to reduce log file size because there is size issue on my production database drive.

and the log become 20 GB to 30 GB with in...

george sibbald (8/15/2010)

---

check out dbcc shrinkfile in books Online.

the notruncate option means do not return space to the operating system so I fail to see why the size of the...