- 论坛徽章:
- 0
|
lEGATO NETWORKER对sql server的日志怎样备份
2
How to Prevent Log Overflow
In Windows, prevent database logs from overflowing available log space by
creating an alert in the SQL Server Performance Monitor that forces an
incremental backup when the database’s log space reaches a certain capacity
(for example, 80% full). An incremental (transaction log) backup truncates the
logs and clears disk space.
To create this alert in Windows NT 4.0 and SQL Server 7.0:
1. Create a batch file (for example, sqlalert.bat) that contains the backup
command and any appropriate command flags, for example:
installpath\nsr\bin\nsrsqlsv.exe
-s NetWorker_server_hostname -l incr -b pool_name
MSSQL:db_Name
PAUSE
In this command, replace installpath with the pathname where the
NetWorker Module software is installed. The pause command is optional.
2. In the Microsoft SQL Server program group, select SQL Performance
Monitor.
3. From the View menu, select Alert.
4. From the Options menu, select Alert. Change the Periodic Update text box
to 10 minutes or more, enough time to run an incremental (transaction log)
backup.
5. From the Edit menu, select Add to Alert.
6. In the Add to Alert dialog box:
a. Select SQL Server: Databases from the Object menu.
b. Select Percent Log Used (%) from the Counter menu.
c. In the Alert If group box, click the Over button and enter 80.
d. In the Run Program On Alert text box, enter the name and full path of
the batch file, for example:
C:\win32app\nsr\bin\sqlalert.bat
e. Select the database to monitor in the Instance text box.
f. In the Run Program On Alert group box, select Every Time.
g. Click Add, then click Done.
具体看manual |
|