Can you run this code and paste the output here:

select log_reuse_wait_desc from sys.databases where name='test'

Replace the word test with actual database name which will tell what is preventing the...

Thanks Jeff and Lowell 🙂

to modify the code in the previous post, i'd write something like...

For simplicity, why dont you create a maintainanence plan for taking backup for all your databases?

Rows_Per_Page = 8096 / (Row_Size + 2)

I've always been confused abt this part of the overall equation. How exactly adding 2 to the number of rows helps in finding rows...

EDIT-double post.

EDIT-double post.

EDIT-double post.

EDIT-double post.

EDIT-double post.

EDIT-double post.

for point 1, please refer sp_addlinkedserver...

If you are adding an article to a publication, you got to re-initialize the snapshot so that new article also becomes a part of the snapshot and hence will move...

Chandu (8/4/2009)

---

I have created a basic Logshipping setup. Primary server runs a job which backups log files every minute. The secondary server copies and restores this log files. And i...

Duplicate post.

Please post your replies Here