Viewing 15 posts - 25,396 through 25,410 (of 26,487 total)
I would turn off the auto shrink. It is possible it is causing some of your issues, as it may be shrinking a database at an inopportune time, like...
November 14, 2007 at 3:20 pm
It would help if you posted the DDL for the table so we could see what you are working with along with what you have actually done so far as...
November 14, 2007 at 11:29 am
I am making the assumption you are running the 32-bit version of SQL Server 2005. With AWE enabled, you may need to remove the 3GB switch and possible need...
November 14, 2007 at 10:28 am
The maintenance plan should have created a log file that should provide you more information regarding the error. The error message itself does not provide enough information.
As for controlling...
November 13, 2007 at 8:36 pm
It will only autoshrink if you have autoshrink turned on (not recommended). You shouldn't shrink the physical size of your transaction log after your log backups as your transaction...
November 13, 2007 at 4:44 pm
Just to be sure, were you looking at the size of the .ldf file on disk after the BACKUP LOG or were you looking at the space in the .ldf...
November 13, 2007 at 4:20 pm
Awesome. If you have any advice for a wanna be author let me know by PM and I'll pass on my daughter's email address to you. She really...
November 13, 2007 at 3:10 pm
Full and Differential backups do not truncate the transaction log. This is only done by a transaction log backupup (BACKUP LOG ...).
November 13, 2007 at 3:08 pm
You can try this:
exec sp_MSforeachtable 'select ''?'' as TableName, count(*) as RecordCount from ?'
I'm sure others will come up with other solutions as well. 😉
November 6, 2007 at 3:02 pm
What would help would be to see some sample data, just as it is in the original file, just reduce the number of rows to something manageable.
November 5, 2007 at 9:48 pm
We may (will) have to revisit how we are doing configurations. The process we use now works fine between developing on our workstations and deploying to our development system....
November 4, 2007 at 6:25 pm
Is there anything in the data to indicate when the data changes from one format to the other?
November 2, 2007 at 5:25 pm
Personally, different data should be in seperate files.
November 2, 2007 at 3:34 pm
Viewing 15 posts - 25,396 through 25,410 (of 26,487 total)