policy-based-managementsql server
I am creating a new policy which shows sproc creation dates. I am based on Stored Procedure facet and appropriate condition is created. Now I want this policy to include only one database in an instance
When I select new policy from the dropdown menu, which is next to every keyword, it shows this
But my point is not to create a new condition for all databases.
My question is, is it possible to to run a policy only for one database in an instance, and if yes, then how?
Thanks for your time!
I would try scripting out the operation instead of running whatever Management Studio is doing "for" you. You shouldn't need to use xp_fileexist (assuming you can validate that the files actually exist in the place the script says). Using 2012 SSMS, I am restoring to a point in time that does not coincide directly with a log backup:
The resulting script in my case was:
BACKUP LOG ... WITH NOFORMAT, NOINIT, NOSKIP, NOREWIND, NOUNLOAD, NORECOVERY
RESTORE DATABASE ... WITH FILE = 1, NORECOVERY, NOUNLOAD
RESTORE LOG ... WITH FILE = 1, NORECOVERY, NOUNLOAD
...
RESTORE LOG ... FROM DISK = [...path from line 1...] WITH NOUNLOAD, STOPAT = <time>
You can certainly limit the set of databases that are checked, using a condition, and have that condition be separate from the actual condition the policy is using to check. Pull down the "Every" drop-down in the UI:
Create a new condition:
Then you should be able to use that condition:
Note that this is using the SQL Server 2012 version of Management Studio (which is now completely free, as of SP1). If the UI does not behave this way in the 2008 R2 version of the tools, upgrade your tools.
Best Answer
Policies are server-wide. But you can have a condition to only bother about the policy based on, for instance, the database name. And that is exactly what that condition that you were about to create would do. So keep creating that for the database name that is relevant for you and you have achieved what you want to achieve.