Dear All

Table structure is as follows

Create table tablea(

Yy numeric(13,3),

Xx varchar(100),

somedate_column datetime)

What i wanted was like cube or rollup is there a way to make single query rather than union

hi all

Got the solution from folloing link . http://dba.stackexchange.com/questions/42068/sql-server-2012-simple-recovery-model-with-log-backup-log-reuse-wait-desc

After creating a DB from SSSM GUI, immidiatly changed the recovery model to full. Then...

Dear Gail

I tried it again today. Attached documeent shows the step i took. But after taking full back up it makes the log_reuse_wait_desc as LOG_BACKUP.

Not able to understand...

Dear Gail

Thank with the script given it working fine. I was trying through SSMS and it was creating the issue. Dont know whats going wrong when i try it from...

Hi Gail

I still get the LOG_backup for simple recovery.

This how i get it in sql 2012-

.created new db with simple recovery

.Created 20000 rows

. took back up (Full)

.till now it showslog_resue_wait_desc...

Hi Gail

Sorry what i meant was "How to check active transaction?" (not log :))

I have done the same steps as you mentioned for testing log behaviour. I had added...

1) steps how i got Log_Backup for the simple

.created new db with simple recovery

.Created 20000 rows

. took back up

.till now it showslog_resue_wait_desc as Nothing

created 20000 more records and now it...

sorry did not realise. I have corrected the screen shot in this attachment.

I created t1 using ssms. and it shows the recovery model as simple

pls find the screen shot in the attachment

Dear All

Thanks for your replies. I have done testing of .ldf file size using 2 newly created DB. One DB is simple recovery model and other Full recovery model.

Created following...

Thanks for quick reply. How do I test this. I need to show the diff that log will not get trucated even if we take full back every day. Can...

Hi Lynn

What you have mentioned is exactly what is present in the procedure. So in such situation we can not view the rows from the Remarks table till the process...

create table remarks ( remark varchar(1000)

create procedure P1 as

begin

while loop

begin

.....

insert into remarks ()

commit

...

issue is resolved. Rollback process was going on hence could not run the disable foregin key command

thanks it worked