Tag Info

Hot answers tagged

3

You can't use dynamic SQL inside a function (well, aside from this awful hack). The main reason is that functions can only return data and can't have side effects. There is no way for SQL Server to prevent you from passing an insert or an update to sp_executesql (as an aside, that looks like a SQL injection attack vector no matter how you end up implementing ...


2

Your index only has 679 pages. Ola's solution is set to ignore indexes with less than 1000 pages (see the @PageCountLevel parameter). You can override that so that it cares about indexes with fewer than 1000 pages, but why? Wasted effort IMHO. I would stop worrying about small tables like this - let Ola's solution do its job, and worry about fragmentation ...


1

Since you said you are beginner and is in learning phase I would give you lot of good articles to learn about SQL Server backup. To start with main question as already mentioned in my comment So can I restore 4th one with 1st one. With out the 3rd ? Differential backup only relates to previous full backup you have taken so NO you cannot restore 4th ...


1

No, it is nothing to be worried about - the Agent isn't considered a clustered service to SQL Server simply because it can't fail over on its own. You should test a failover and be confident that SQL Server Agent will start on the other node and that jobs will run etc. (sometimes there can be local dependencies that won't exist on the other node(s)), but ...



Only top voted, non community-wiki answers of a minimum length are eligible