SQL Server Agent Files on Disk

Question

Hello,

i was working on migaret all SQL Server database(SYETEM & USERS) files from the old storage to the new storage (SQL Server 2008 x64 clusterd) , after i moved all database user and system to the new storage i take all old disks offline to test and and all resource came online except SQL server agent and SSAS..

I need to know how to move any files related to the both services Analysis and SQL Agent to the new Disks ..please note that for old disks am going to remove them completely from cluster so SQL Server won't be able to access them any more ..

 

Thanks

Answer 1

Sql Server agent settings are stored in msdb database. Binaries are stored with Sql Server installation. You will need to review the jobs if they are not saving output to text files located on the disks you are planning to remove.

Itegration packages can be moved by simply copying dtsx and configuration files to another drive

---

With kind regards
Krystian Zieja
http://www.projectnenvision.com
Follow me on twitter
My Blog

Answer 2

but I don't have any DTSX hosted on the server !!! also have moved the SQL Server agent settings to the new location and still have the same problem???

Answer 3

Hello,

i was working on migaret all SQL Server database(SYETEM & USERS) files from the old storage to the new storage (SQL Server 2008 x64 clusterd) , after i moved all database user and system to the new storage i take all old disks offline to test and and all resource came online except SQL server agent and SSAS..

I need to know how to move any files related to the both services Analysis and SQL Agent to the new Disks ..please note that for old disks am going to remove them completely from cluster so SQL Server won't be able to access them any more ..

 

Thanks

What error messages you see in the SQL Server Agent Log, System\Application Event Log?

---

Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @PradeepAdiga

Answer 4

Hi,

Are you able to see SQL Agent out file ,in drive ?

If you are able to open it using text editor ,please check when it is modified recently by agent.

I suspect  problem with this agent out file.

Location of out file is C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLAGENT.OUT (path can be vary  )

If you found any problem ,enter into regedit

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\SQLServerAgent

Here u should find the exact path for this file,Change it according to your new drive location.

Reply u r comments

---

Sivaprasad.L Together We can Achieve