Backup and Truncate Transaction Logs
Save the transaction log and truncate the file to prevent Tlogs FULL Error
2008-12-16 (first published: 2008-11-17)
2,685 reads
truncate log
RE: SQL Agent Starting - MS Cluster
Check a couple of things. One the account that sql server and the agent are set two run under have enough permissions to start i.e. usually a domain acount with local admin rights on each node. Two, check your dependancies in cluster admin and make sure that sql owns everything it needs to fail over […]
2003-12-04
1 reads
RE: Schedule a DTS package
Great ! It works well. Thanks for your help. I really appreciate this forum as members are very helpful.
2003-12-04
RE: Schedule a DTS package
quote: Hi, like i m a newbie in DTS, i don't understand some thiongs about it. I want to schedule a DTS to be executed as a job. When i right click on my package to schedule it, no problem. When i go to SQL Server Agent/Jobs, i've got nothing ! Why ? Can't explain […]
2003-12-04
2 reads
RE: SQL database backup from Arcserve2000
Hi, there, Normally, we only backup the system databases and user databases to tape devices through the ARCserver or other netbackup software. It does not need to back up the SQL database files. And it is recommanded to do some research on www.ca.com and maybe you could get the answers. Good Luck.
2003-12-02
1 reads
2003-12-01
1 reads
RE: Server Room Schedule
Haven't seen one. Used Excel myself. Steve Jones sjones@sqlservercentral.com http://qa.sqlservercentral.com/columnists/sjones www.dkranch.net
2003-06-09
2 reads
RE: Error Traps In Triggers
By any chance is there a "working" SQL statement before the @@ERROR is checked - @@ERROR resets with every SQL statement... so if there was an error in an SQL statement and @@ERROR was not checked immediately after this statement did not execute but rather was checked after another "correct" SQL execution then the value […]
2003-06-04
1 reads
Blogs
SQL Saturday Boston 2024 Slides
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers