1. You could give our product, MiniSQLBackup, a try. It can generate smaller backups for you.2. If you set to overwrite, that means you will only have the latest backup. If you consistently copy this backup file to another location/server and tag them accordingly, it should be fine.3. tempdb grows usually because of temporary workspace needed for sorts […]
2004-09-22
If you are running the DTS package as a job, your SQL agent needs access to the operating system file. That means your sql agent must be started with windows authentication.
2004-08-26
Hi,I'm an intermediate user of SQL as a developer. I've created an audit table in which I want to record which column has been updated and its old and new values. Among other functions, I'm using COLUMNS_UPDATED to determine which columns have been updated.I create the SQL dynamically based on which column was updated. This […]
2004-07-01
1,203 reads
Thank you all for the input so far.You all right about the transaction logs and ArcServe. I went into the ArcServe event log for the backups and found that unlike SQL, only the database is backed up. While it does perform a proper Checkpoint, the log is not truncated and the actual Transaction Log device is […]
2004-02-05
2 reads
No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!
2003-06-23
Hi, I reinstalled the SQL Server + SP3 but nothing has changed. The Agent still can't be started :((( I have 2 ideas left: 1. Something is wrong with the operating system. 2. There's a setting that prevents the Agent from starting. But what could it be??? Any other idea? Thanx, Csaba Csaba Mezo (mezo@inform.hu)
2003-06-20
1 reads
By Steve Jones
Thanks to everyone that came to my talks. Slides are below. Best Practices for...
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers