Database Administration for Specific Platforms › SQL Server/Windows Routine Procedures › Backing Up Transaction Logs › Create a Transaction Log Dump Device for Each CSE Database

Create a Transaction Log Dump Device for Each CSE Database

Follow these steps:

1. Create a transaction log dump device for the <DBCSE> database using Management Studio, for example:

   sp_addumpdevice 'disk', 'DBCSE_LOG_DUMP', 'D:\ENCYLOG.DMP', 2
   

2. Create a transaction log dump device for the <DBDIR> database using Management Studio, for example:

   sp_addumpdevice 'disk', 'DBDIR_LOG_DUMP', 'D:\DIRLOG.DMP', 2