Does anyone know what status 112 is. I looked in BOL and it said "Variables are not allowed in the %ls statement." ?? Any thoughts would be greatly appreciated. Thanks.
Could you be a little more descriptive with the problem scenario. I am guessing it is an I/O error. Check the disk space and see if it is full. BTW, what is your disk setup? This article may provide some insight: http://support.microsoft.com/default.aspx?scid=kb;en-us;325334 - Tahsin
Yes. You were absolutely correct. The disk was out of space. Thanks! quote:Originally posted by Tahsin Could you be a little more descriptive with the problem scenario. I am guessing it is an I/O error. Check the disk space and see if it is full. BTW, what is your disk setup? This article may provide some insight: http://support.microsoft.com/default.aspx?scid=kb;en-us;325334 - Tahsin
Well done Tahsin!!!!!!! Luis Martin Moderator SQL-Server-Performance.com Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason. Leonardo Da Vinci Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte All postings are provided “AS IS†with no warranties for accuracy.
Post the queyr used to backup the database/log for further investigations, in addition to what has been referred above. Satya SKJ Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by LuisMartin</i><br /><br />Well done Tahsin!!!!!!!<br /><br />Luis Martin<br />Moderator<br />SQL-Server-Performance.com<br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Thanks Luis [<img src='/community/emoticons/emotion-2.gif' alt='' />]
BACKUP DATABASE [Database] TO DISK = N'E:BackupDatabase_Test_Backup' WITH INIT , NOUNLOAD , NAME = N'Database backup - Nightly Full', NOSKIP , STATS = 10, NOFORMAT DECLARE @i INT select @i = position from msdb..backupset where database_name='Database'and type!='F' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name='Database') RESTORE VERIFYONLY FROM DISK = N'E:BackupDatabase_Test_Backup' WITH FILE = @i quote:Originally posted by satya Post the queyr used to backup the database/log for further investigations, in addition to what has been referred above. Satya SKJ Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
