remove extra log files
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
I have 3 log files and need to remove couple of log files from one of my DB
in sql server 2005 and keep only one log file , so moving all the logs from
these two log files to other 3rd log file which i want to keep ,what are the
steps i need to take care for this action?
Thanks for your time!!
.
Relevant Pages
- Re: Move DB File Locations - SQL 05
... to move tempdb data file to the raid 10 and the log file to the Raid 1 along ... http://www.databasejournal.com/features/mssql/article.php/3379901 Moving ... for SQL Server ... my log files to a RAID 1 D: drive, and my Data Files to a RAID 10 E: ...
(microsoft.public.sqlserver.setup) - RE: Installing SP4 on SQL 2000
... tomorrow to see where the log files are. ... SQL Server 2000 SP4 is 8.00.2039. ... MCITP: Database Administrator ... "David G" wrote: ...
(microsoft.public.sqlserver.setup) - RE: Installing SP4 on SQL 2000
... Another place to check for install log files is in C:\Program ... MCITP: Database Administrator ... "David G" wrote: ... should I have SQL Server on? ...
(microsoft.public.sqlserver.setup) - RE: How to change the error log location?
... for any SQL Server 7.0 or SQL Server 2000 database. ... Change the path for the master data and log files in SQL Server Enterprise ... -d is the fully qualified path for the master database data file. ...
(microsoft.public.sqlserver.server) - Re: Advice Requested : Disaster Recovery with 2 Drives (No Raid) with SQL Server 2008
... As far as splitting the transaction log files and the data files, that's always a good strategy, but for a 1.3GB database... ... I am running SQL Server 2008 Enterprise, ... backups every 4 hours to one of the two Drives. ...
(microsoft.public.sqlserver.programming) |
|
