SQL Server and SQL Server Agent Service Account(Startup Account) and Permissions

SQL Server and SQL Server Agent service account(Startup Account) and Permissions 1.Does service account need sysadmin role?  [SQL Server(Database Engine)] 沒有文件說明一定需要sysadmin role no document found saying No or Yes explicitly about if sql service account need to be a member of sysdamin role (1)SQL 2005,service account is always granted with sysadmin by default (e.g. if we pick Local…

0

AlwaysOn Availability Groups learning resources

Overview of AlwaysOn Availability Groups (SQL Server)http://msdn.microsoft.com/en-us/library/ff877884.aspxPrerequisites, Restrictions, and Recommendations for AlwaysOn Availability Groups (SQL Server)http://msdn.microsoft.com/en-us/library/ff878487.aspx SQL AlwaysOn Team Bloghttp://blogs.msdn.com/b/sqlalwayson/SQL Server Customer Advisory Teamhttp://blogs.msdn.com/b/sqlcat/ MSDN Blogs  >  Brad Chen’s SQL Server Blog   >  All Tags  >  alwayson http://blogs.msdn.com/b/bradchen/archive/tags/alwayson/ AlwaysOn Architecture Guide: Building a High Availability and Disaster Recovery Solution by Using Failover Cluster Instances and…

0

How to create a failover cluster

1.In the Failover Cluster Manager snap-in, confirm that Failover Cluster Manager is selected and then, under Management, click Create a Cluster. 2.Follow the instructions in the wizard to specify: The servers to include in the cluster. The name of the cluster. Any IP address information that is not automatically supplied by your DHCP settings.  …

0

Query SQL Server backup history and restore history records

  1.使用以下TSQL語法查詢備份檔紀錄 SELECT bs.backup_set_id, bs.database_name, bs.backup_start_date, bs.backup_finish_date, CAST(CAST(bs.backup_size/1000000 AS INT) AS VARCHAR(14)) + ‘ ‘ + ‘MB’ AS [Size], CAST(DATEDIFF(second, bs.backup_start_date, bs.backup_finish_date) AS VARCHAR(4)) + ‘ ‘ + ‘Seconds’ [TimeTaken], CASE bs.[type] WHEN ‘D’ THEN ‘Full Backup’ WHEN ‘I’ THEN ‘Differential Backup’ WHEN ‘L’ THEN ‘TLog Backup’ WHEN ‘F’ THEN ‘File or filegroup’ WHEN ‘G’…

3