When you setup LS, you can schedule the Backup...

Im just a little confused how the log shipping works.

I was thinking it was a DB Backup, then adding all the incrimental logs to build up the same state as...

Thanks and I've written another article about evaluating policies on mutliple instances (SQL 2008 , 2005 and 2000), that will be published end of this month, I hope that...

The PBM is focused only on SQL Server object but not the physical server objects. You can check/verify defined metric values of individual objects in an instance but can not...

Yes its all upto your use, as per my experience the restore is really faster than the native compressed database in sql 2008. And specially you can do object level...

Scenario 1. If the primary server act as a secondary server and the Primaryserver backup and destination backup path are same then LS Copy is not required and you can...

MS SQL doesnt have option to restore a table from the backup file, but third party tools are supporting this feature. If you are using Quest LiteSpeed then you can...

Thanks for your Questions and clarifications... Special thanks to Steve...

Still lot of tricks to learn in PBM, will post it soon...

Thanks

Jay

http://www.sqldbops.com

But unfortunately there is no facet in PBM for physical Disk volume as per my knowledge, if so it would have got Disk volume properties liek space values as well...

Using Data_File facet has multiple properties including @Size,@UsedSpace, if we Subtract(@Size,@UsedSpace) them then will get the current free space in kilobytes. From that value you can determine whether it meets...

Thanks for your comments...

No specific reason, both methods will give the same result...

Thanks for your tip Muthu.

I'm able to evaluate the policy on multiple instances through registered servers group. Also I'm looking for the purpose of Server facet on Server Restriction...

if I understood correctly,

Facets are predefined and we can not write any user defined T-SQL statements on the conditions, may in future editions.

Also we can evaluate the policies only...

Thanks for your tip.

@@servername is cached data, recycling the SQL service will resolve this issue.

SERVERPRORTY('servername') should tell you the current renamed server name.

Thanks

Jay.