Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elaian84
Starting Member
1 Post |
 Posted - 2006-09-27 : 02:34:18
|
| Salam,I am creating a maintenance plan to take Backups, the Full backup done but the differential and log Transaction backups did not work, and did not delete the Log Transaction Backups.and this error in the job History :Executed as user: NT AUTHORITY\SYSTEM. Cannot shrink log file 2 (horizons1_SITE_log) because all logical log files are in use. [SQLSTATE 01000] (Message 9008) DBCC execution completed. If DBCC printed error messages, contact your system administrator. [SQLSTATE 01000] (Message 2528) Cannot open backup device 'C:\backup\iHorizons1_SITE\iHorizons1_SITE.dmb'. Device error or device off-line. See the SQL Server error log for more details. [SQLSTATE 42000] (Error 3201) BACKUP DATABASE is terminating abnormally. [SQLSTATE 42000] (Error 3013). NOTE: The step was retried the requested number of times (5) without succeeding. The step failed.Plz Help me if you can !!!thank youAhmad ElayyanSoftware EngineerDBA-Assistant |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-09-27 : 05:14:28
|
| Seehttp://www.nigelrivett.net/SQLAdmin/TransactionLogFileGrows_1.htmlIt explains why your differential backup does not release log file space and what to do about it.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Error In Diffrantioal Back up