Hi all. I'm using SQL Server 2000.
Is it possible to change the location of a tran log for an existing db? The tran log is located at the following location "D:\logs\DBName_Log.ldf", but under the db properties, the location is listed as "D:\logs\\DBName_Log.ldf". I didn't create the db, so I'm not sure how this happened. I don't actually want to change the physical location of the tran log, but just want to remove the extra "\" from the location in the db properties.
Anyone have any ideas on how to go about this?
Thanks in advance for the help!
Is it possible to change the location of a tran log for an existing db? The tran log is located at the following location "D:\logs\DBName_Log.ldf", but under the db properties, the location is listed as "D:\logs\\DBName_Log.ldf". I didn't create the db, so I'm not sure how this happened. I don't actually want to change the physical location of the tran log, but just want to remove the extra "\" from the location in the db properties.
Anyone have any ideas on how to go about this?
Thanks in advance for the help!