January 23, 2008 at 6:42 am
Hi
I got "Error 21268 [SQL-DMO]Row or column specified is outside the range of the specified query results set"
when i use a script for backup of a DB.
If i use maintenance plan inside SQL server then everything is working fine
The script:
"C:\....\....\...\sqlmaint.exe -S localhost -U user -P passw -PlanName DBBup -BkUpDB D:\BUP\ -BkUpMedia DISK -VrfyBackup -Rpt D:\RPT\DBbup.rpt
OS W2003 Sp1
MSSQL 2005
Someone know.....:)
January 23, 2008 at 3:04 pm
I don't pretend to know, but I have one question - is the database set to level 80 or 90? Could there be compatibility issues that the maintenance plan covers, but the .exe does not? How did you build your maintenance plan - are you truly comparing apples to apples?
January 23, 2008 at 7:54 pm
Did you check the discussion in this forum recently?
http://www.sqlservercentral.com/Forums/Topic255556-5-1.aspx#bm255664
January 24, 2008 at 6:41 am
Sorry, but are you using SQL Server 2005 ?
Have you verified the compatibility to SQL server 2005 with the command:
sp_dbcmptlevel
that have to give as result:
"The current compatibility level is 90."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply