Viewing 15 posts - 46 through 60 (of 80 total)
Hello,
The SQL Server Error Log has an entry for the database backup for all databases, system and user....all starting at 01:00:41.
Date27/09/2011 01:00:41
LogSQL Server (Current - 18/09/2011 06:06:00)
SourceBackup
Message
Database backed up. Database:...
September 28, 2011 at 6:42 am
hi stewartc,
thank you very much for this....i have tested and all works!!
once thing....it was only collecting system database stats until granted extra permissions to all user databases. i will alter...
August 17, 2011 at 4:20 am
thank you for these....i will test these as soon as possible 🙂
August 17, 2011 at 3:24 am
hello,
i have tried that a number of ways but keep getting the error:
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '@P1'
i havent used this exec method before and...
August 16, 2011 at 8:57 am
yeah i know....but we dont have the space on most systems....or the budget to allocate it if the customer decides they will not pay for it....
im still finding it hard...
July 7, 2011 at 5:42 am
hi george,
currently we backup multiple SQL 2005 and SQL2008 servers to a SATA disk location....but this is old and very slow and we are unable to write multiple backups at...
July 7, 2011 at 5:25 am
i was thinking it may be easier to stop the log backups for a couple hours as opposed to having to increase the number of logs for restores (and restore...
July 7, 2011 at 4:25 am
thats what i was looking for!!! surprising i havent been able to find that states anywhere until now!!
i will look into making changes to stop tlog backups during the differentials...
July 7, 2011 at 4:10 am
ok thanks George....we will be running full recovery tests but that question got me stumped and wasnt able to answer it.
It relates to one of my original questions....which is:
if there...
July 7, 2011 at 4:02 am
ok i may have worded my question incorrectly....try this:
when creating a recovery solution you can avoid restoring massive numbers of log files by running differential backups daily instead of fulls
so....if...
July 6, 2011 at 4:11 pm
my boss who ran this told me there was no uncommitted transaction as that would mean the sp rolled back without any notification....and the archving confirmation would never have been...
July 3, 2011 at 6:03 pm
as i didnt run this myself and am relying on what i have been told i cannot say 100% there was no nested transaction as this could happen if trying...
July 3, 2011 at 5:39 pm
hi gail,
yeah due to the way the sp is written there is a commit or a try/catch block with rollback....then a confirmation written. the query executed successfully and the confirmation...
July 3, 2011 at 5:00 pm
no i did have that issue before which is why i added the %hbu% clause to the select and altered my job name to fall under that clause
i was told...
March 4, 2011 at 5:09 am
Hi Ian,
I have just had a nice conversation with someone about advanced logic and i think i understand!!
To explain for any others that may be confused....and to check my findings:
when...
March 4, 2011 at 4:52 am
Viewing 15 posts - 46 through 60 (of 80 total)