Below are the details that I setup for testing:

Backup job = Every 5 min.

Copy Job = Every 5 min.

Restore Job = Every 7 min.

Delete files older than = 30 min.

Delete...

Thanks for the reply, below are the result of both the queries:

Result:

Primary_id=548492AD-0BDB-4A2E-B31E-BD32BDED52CF

Primary_database=AdventureWorksDW

Backup_directory=D\backup_ls

Backup_share=\\192.10.10.1\Backup_ls

Backup_retention_period=30

Backup_compression=2

Backup_job_id=

monitor_server=Null

Monitor_Server_security_mode= Null

Backup_threshold=20

Threshold_alert=14420

Threshold_alert_enabled=1

last_backup_file=D:\backup_ls\AdventureWorksDW_2012071071012.trn

Last_backup_date=2012-07-10

History_retention_period=5760

Against the secondary

exec sp_help_log_shipping_secondary_database

@secondary_database = 'yourdatabase'...

I will suggest Snapshot replication.

I again reconfigure log shipping for testing and found that restore job is failing, backup and copy job is working fine.

What could be the issue?

According to my knowledge, they will not be deleted on secondry server, it will be deleted on Primary server.

Thanks a lot for the information ! I read Level 1 to level5 and its been very useful, everything given in very detail and had cleared many doubts and question.

I...

From the error I can say Connection handshake failed, target system is ignoring it. Might be firwall at target system(mirrored Machine) is blocking it. So pls check that and if...

1. Connect to the excel sheet using JET oledb.

2. Query the whole sheet and create a datatable which contains the excel data now.

3. Delete the first row of Datatable.

4. Update...

That means...

Thanks a lot Jason !

And I got one more article from Stairways tab...."Stairway to Transaction Log Management in SQL Server" in our site itself which has some details explanation in...

Sean Lange (7/3/2012)

---

It makes sense if you think about it. You are talking about pushing modified rows contents to another database. Without a primary key how do you know which...

Thanks a lot Jason for quick response,

But the article dont have any detail explanation of that mechanism. I want more details that how it truncate the inactive part? What type...

Thanks a lot GilaMaster !

given information is very useful.

Thanks again.

sufiyan.sarguroh (6/8/2012)

---

Hi All,

The dynamic view sys.dm_db_index_physical_stats gives us the external fragmentation value in percent. Is there any way we can find the internal fragmentaion value ? And does the index...

External Fragmentation: External Fragmentation happens when a dynamic memory allocation algorithm allocates some memory and a small piece is left over that cannot be effectively used. If...