Steps to change the default location of SQL Server /SQL Server Agent - Error log files
来源:互联网 发布:淘宝店怎么申请 编辑:程序博客网 时间:2024/05/29 04:45
今天早上同事让我将SQL Server的数据文件和系统文件迁移到存储上面,盘符等都修改,迁移数据文件和Mater/error log之后,将之前的磁盘从dependency中去掉,旧的盘OFFLIEN,然后做Failover测试发现SQL Agent没起来,突然想到SQL Agent也有路径要修改。当时已经不记得怎么改了,网上搜到下面这篇文章,希望以后带大家也有帮助。
Recently came across a customer scenario, wherein the 'ask' was to change the current location of SQL Server Errorlog files to a different location. Here’s a simple way to get this done:
Steps to change Location of SQL Svr Errorlog files
Step 1. First, identify the current location of SQL Server Errorlog files.
Refer my previous post on How to: Verify path for SQL Server Error Log Files
Step 2. For error log parameter "-e", change the current path to new location.
-e<New_Errorlog_location_here>\ERRORLOG
WARNING: Make sure that correct folder exists else consecutive attempt to start SQL Server service will fail with error “The request failed or the service did not respond in a timely fashion….”
Step 3. Re-cycle the SQL Server service for changes to take effect.
Step…
Steps to change Location of SQL Svr Agent Errorlog
Step 1. This is relatively simple and can be done using below code:
USE msdb
GO
EXEC msdb.dbo.sp_set_sqlagent_properties @errorlog_file=N'<New_Errorlog_Location>\SQLAGENT.OUT'
GO
- Steps to change the default location of SQL Server /SQL Server Agent - Error log files
- How to change the SQL Server 2008 default install path
- How to change the SQL Server 2008 default install path
- Change the log files location of a WebLogic Domain
- Shrink SQL Server Log Files
- SQL Server Error Log 管理
- 查看SQL Server error log
- Restore SQL Server 2005 error : "The tail of the log for the database "TEST1" has not been backed up."
- sql server 2008 R2 Error 9003:The log scan number passed to log scan in database is not valid
- Using Reporting Services to Search the SQL Server Log
- Change Log of Joomsport: Error in Joomsport (Synchronized with Server)
- 3 Methods to Change SQL Server Password
- How to change the default location of the Office 2010 Document Cache
- SQL SERVER AGENT SECURITY
- Change the value of "Maximum number of concurrent connections" about SQL Server 2012
- mapping of SQL Server driver to the JDBC data types
- How to enable the IntelliSense of SQL Server 2008
- SQL Server Express 没有 SQL Server Agent
- 各种语音编码总结
- 怎么用PDF格式转成PPT
- Android 线程池来管理线程
- android GPS JAVA应用程序编程-------获得经纬度,卫星信息等
- iOS字符串去掉空格
- Steps to change the default location of SQL Server /SQL Server Agent - Error log files
- EditText 中google原生态键盘del键无法响应onkeyListener事件
- java进制
- 深入浅出OOP(三): 多态和继承(动态绑定/运行时多态)
- Struts2之文件上传
- Hadoop2.6分布式 automatic HA+Federation+Yarn教程
- [iOS]PDF格式的矢量图作为图片资源自动适配
- physdiskwrite使用教程
- HDU 1028 Ignatius and the Princess III