how are you measuring log file size?

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 log file...

uniqueidentifier does not implicitly convert to int, you will need to use convert or cast.

http://msdn.microsoft.com/en-us/library/aa226054(v=SQL.80).aspx

shrinkfile with notruncate will have no effect on a log file.

I can only presume one log restore is using the log shipping jobs, one isn't?

the version of SQL will not...

this is a known bug with the 64bit install GUI. google that error you will find a number of posts on it.

your options are -

1) leave shared directories to...

do not run any log backups outside of the jobs created by the logshipping wizard to do so. Only those log backups will be copied and restored,. Other log backups...

you changed the name of a mirroring endpoint after it was in...

get together with your SAN guy and tell him you need your database log and tempdb IO activity separated and what is he going to do to provide that for...

if you don't change it in SQL as well via configuration manger service will fail on next restart.

control the log file growth by taking log backups more frequently. Avoid shrinking the log file.

If you shrink files on a database acting as primary in logshipping that action...

no, and there will never be a need to do...

Rajat Jaiswal-337252 (8/12/2010)

---

I am just guessing if its possible " take database backup after a particular date suppose primary server fail on 1 august and back in action on 4...

this limit of 10 databases per server for database mirroring is a bit of an urban myth, in reality it depends on a lot of factors and is likely to...

In logshipping I usually run sql server and sqlagent services on both servers under the same domain user account, avoids a lot of access problems.

Make sure the log backup directory...

afraid so, but in a situation where primary is lost unavoidable.

In a test failover can be avoided by doing tail backup of the log.