Viewing 15 posts - 991 through 1,005 (of 4,745 total)
It sounds like the instance is down. Check whether the instance is in fact running via configuration manager, if not check the latest error log to see why it is...
---------------------------------------------------------------------
June 15, 2012 at 5:08 pm
which means if you can get hold of backups easily and quickly going back say 3 days, run checkdb every 3 days.
---------------------------------------------------------------------
June 15, 2012 at 4:59 pm
when the restore job runs successfully files that are older than your retention period will be deleted.
If the restore is successful older files will by definition already have ben restored...
---------------------------------------------------------------------
June 14, 2012 at 4:04 am
its the restore job that deletes the files no longer required.
---------------------------------------------------------------------
June 13, 2012 at 3:52 pm
antonio.reyes (6/12/2012)
Internal I/O Request 0x2307A6E8:Op:Write, pBuffer:0x079F0000, size:983040, Position:663024113152,UMS:Internal:0x103, Internal High:0X0, Offset:0x5F511600,Offset High:0x9A, m_buf:0X079F0000,m_len:983040,m_actualBytes:0,m_errcode:112,Backup FileAntonio
OS error 112 = not enough space on drive, so yes this is a space error
---------------------------------------------------------------------
June 13, 2012 at 8:07 am
is the query slow? you say you drop the index and key lookup goes, what is it replaced by, a table or clustered index scan? Is the query faster or...
---------------------------------------------------------------------
June 12, 2012 at 5:06 am
Sachin Nandanwar (6/12/2012)
Ideally you shouldn't be having a log backup job when you have log shipping doing it for you.
to reinforce that you definitely shouldn't have other log backup jobs...
---------------------------------------------------------------------
June 12, 2012 at 1:49 am
you can restart from a differential if no further full backup of the primary has been done since the one used to initialise logshipping, i.e. the primary and the secondary...
---------------------------------------------------------------------
June 12, 2012 at 1:43 am
when logshipping the only backups of the log must be done via the logshipping jobs.
You will have to remove the 10 min log backups outside of logshipping and change the...
---------------------------------------------------------------------
June 11, 2012 at 3:44 pm
thanks for posting back.
---------------------------------------------------------------------
June 5, 2012 at 12:23 pm
use the rolling upgrade method:
http://support.microsoft.com/kb/958734
---------------------------------------------------------------------
June 4, 2012 at 12:52 pm
you can restore log backups to a copy_only full backup, I just tried it. You should confirm it for yourself by trying it.
As Michael says, normal full backups do not...
---------------------------------------------------------------------
June 1, 2012 at 10:23 am
the share where the logs are backed up to has to be a cluster resource so it fails over when the sql instance does, that way its visible on either...
---------------------------------------------------------------------
June 1, 2012 at 7:35 am
the maximum number of databases per instance is 32767, therefore the maximum DBID = 32767, I would say thats the reason this number was chosen for the resource database,...
---------------------------------------------------------------------
May 31, 2012 at 3:59 pm
is that restarting SQL, or restarting the server?
I would take this up with the SAN people, and as jared says, make sure you are not looking at mapped drives rather...
---------------------------------------------------------------------
May 31, 2012 at 10:37 am
Viewing 15 posts - 991 through 1,005 (of 4,745 total)