[MS SQL Server] Minimum Permission to create a database snapshot |
- Minimum Permission to create a database snapshot
- Query to determine if SQL Agent is up?
- To create updatable subscription in single side replication
| Minimum Permission to create a database snapshot Posted: 14 Jun 2013 02:24 AM PDT Hi Experts,I know the permission required to create a DB snapshot is same as creating a database. Can anyone please let me know how to give minimum permission for creating the same other than dbcreator.Thanks in Advance |
| Query to determine if SQL Agent is up? Posted: 13 Jun 2013 08:43 AM PDT To check for recent failures of maintenance jobs, a person can run a query such as -- Identify SQL Agent jobs (and maintenance plan subplans) that have failed in the last few days.-- If the Agent is not running, jobs will not start and this query will not find any problems. use msdb go select convert(char(13),server ) as Server , convert(char(60),name ) as JobName , convert(char( 7),step_id ) as StepNum , convert(char(35),step_name) as StepName , dbo.agent_datetime(run_date, run_time) as RunDateTimefrom sysjobhistory, sysjobswhere sysjobhistory.job_id = sysjobs.job_id and -- join tables step_id <> 0 and -- do not select job overview, only the details run_status <> 1 and -- select failed jobs datediff -- last few days ( day, dbo.agent_datetime(run_date, run_time), getdate() ) <= 8order by Server, JobName, StepNum, StepName, RunDateTime desc -- most recent jobs firstThat's all very nice but does not help much if the Agent is down and jobs don't even start running. Is it possible to run a T-SQL query to determine if the agent service is running? If you've got a lot of database servers to check, it would sure be convenient to run a query on all of them to check agent jobs and another query to make sure the agent service is up. |
| To create updatable subscription in single side replication Posted: 13 Jun 2013 06:23 AM PDT Suppose i have to replicate a table from production to reporting server. Production is publisher and report server is subscriber. It is also required that table data may be updated at subscriber. However updates on subscriber should not be send back to publisher. Is it possible to configure such a setting for replication?Thanks |
| You are subscribed to email updates from SQLServerCentral / SQL Server 2008 / SQL Server 2008 Administration To stop receiving these emails, you may unsubscribe now. | Email delivery powered by Google |
| Google Inc., 20 West Kinzie, Chicago IL USA 60610 | |
No comments:
Post a Comment