Activity overview
Latest activity by spireite
David, I'll 2nd Word as well! / comments
David, I'll 2nd Word as well!
David,
Could I possibly suggest PDF (with hotlinks) ? We use Sharepoint as a repository, and we find PDF much better to put in to Sharepoint. / comments
David,
Could I possibly suggest PDF (with hotlinks) ? We use Sharepoint as a repository, and we find PDF much better to put in to Sharepoint.
If I execute the Agent entry manually, then that database does backup through SQLBackup. / comments
If I execute the Agent entry manually, then that database does backup through SQLBackup.
If SQLServers' SQL Agent handles it, what the SQL Backup Agent Service for?
I now have another issue - in the full backup, there are 15 databases, its does all but one - which generates the following error - this is slap bang in the middle of the all the other database handles by that one job.
25/05/2006 00:00:21: VDI error 1010: Failed to get configuration from server. Check that the SQL Server instance is running, and that you have the SQL Server Systems Administrator server role. Error code: (-2139684861: The api was waiting and the timeout interval had elapsed.)
25/05/2006 00:00:21: SQL error 3013: BACKUP DATABASE is terminating abnormally.
25/05/2006 00:00:21: SQL error 3007: The backup of the file or filegroup "sysft_ftcat_documentindex" is not permitted because it is not online. BACKUP can be performed by using the FILEGROUP or FILE clauses to restrict the selection to include only online data.
25/05/2006 00:00:21:
25/05/2006 00:00:22: Memory profile
25/05/2006 00:00:22: Type Maximum Minimum Average Blk count Total
25/05/2006 00:00:22:
25/05/2006 00:00:22: Commit 24707072 4096 80590 9788 788815872
25/05/2006 00:00:22: Reserve 330825728 4096 115204 8979 1034424320
25/05/2006 00:00:22: Free 161202176 4096 2064827 157 324177920
25/05/2006 00:00:22: Private 330825728 4096 95330 18331 1747501056
25/05/2006 00:00:22: Mapped 1060864 4096 112900 55 6209536
25/05/2006 00:00:22: Image 24707072 4096 182492 381 69529600
25/05/2006 00:00:22:
/ comments
If SQLServers' SQL Agent handles it, what the SQL Backup Agent Service for?
I now have another issue - in the full backup, there are 15 databases, its does all but one - which generates the followi...
Both times match between the GUI and Management Studios schedule. In the end I rebooted the server and the schedule seems to be ok now since the reboot. Does this help? / comments
Both times match between the GUI and Management Studios schedule. In the end I rebooted the server and the schedule seems to be ok now since the reboot. Does this help?
Scheduled job is running too many times!
Hi,
I have a SQL2005 SP1 server, and SQLBackup 4.2. I have two jobs...
1. A Log backup scheduled every 30mins
2. A FULL db backup once a night (midnight)
I have a problem though. The Full backup ...
Suggestions.... (Helpful I hope)
I've had a play with the tool, but there is what appears to some glaring omissions for me....
1. A quick way of setting the colour shemes for object types would be good for me. e.g Set All Stored P...
Running a SQL Data Compare script from a .NET app...
Can I ask how you do it? I have an application in VB which uses SQL-DMO to run the SDC geberated scipt.. Is there a way in .NET to run this script WITHOUT needing DMO, or do I need to still use D...