September 22, 2016 at 11:39 am
So in our backup location the xel file is being written to and is locked. We setup a new location for the backups (FULL,DIFF,TLOGS) to be written. However the xel file is locked due to it being written to, how can or how do I change the location it is being written to? this file is from a SQL 2012 box. Not sure if I have posted all needed but some guidance would be nice. Thank You.
September 22, 2016 at 12:30 pm
Can you post whatever errors you are getting and what you are doing when the errors are generated? Errors in the SQL Server log, errors in whatever process - backup?
Sue
September 22, 2016 at 12:40 pm
The dba before me has a backup process running, network guys are killing the current server and if we manually do a backup and restore it breaks the chain off current backups, What network guys have done is created the top level directory and wanted me to backup and restore, in the backup process there is a value in a settings table that all I need to do is change to the new location and it writes the files there, as long as the directory\DIFF, FULL, TLOG is there. This works fine, however there is a wv-sqldev3_DBUse_0_131188796533480000.xel file that when trying to copy it won't, says it is being used. So I want to take the server offline to stop it from writing to that file, and point it to the new location. Where do I find this setting, in the master db the table server_event_session_fields has the original value but, as you probably know I can't just merely change it there to the new path. So was wondering where this is set.
September 22, 2016 at 4:47 pm
cbrammer1219 (9/22/2016)
The dba before me has a backup process running, network guys are killing the current server and if we manually do a backup and restore it breaks the chain off current backups, What network guys have done is created the top level directory and wanted me to backup and restore, in the backup process there is a value in a settings table that all I need to do is change to the new location and it writes the files there, as long as the directory\DIFF, FULL, TLOG is there. This works fine, however there is a wv-sqldev3_DBUse_0_131188796533480000.xel file that when trying to copy it won't, says it is being used. So I want to take the server offline to stop it from writing to that file, and point it to the new location. Where do I find this setting, in the master db the table server_event_session_fields has the original value but, as you probably know I can't just merely change it there to the new path. So was wondering where this is set.
I think I may know what you are talking about now. You have an extended event? And it's logging to a directory that you want to change? Is that the issue? That's my only guess.
If you are used to managing these at all, you'd want to alter the session to stop it, then add your new target with a new file path and then drop the old one with the old file path. If you have no idea what I am talking about then try using the GUI to modify the event. That's what you may be saying you can't find - how to modify an extended event. In SSMS, go to Management, then to Extended Events, then to Sessions. Right click on the session and select Properties.
Hope you are referring to Extended events, that's my best guess.
Sue
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply