CirquedeSQLeil (1/5/2010)

---

Krasavita (1/5/2010)

---

Logged on to SQL Server 'MDSVSQL' as 'CUSTOMDIRECT\sqlservices' (trusted)

[Microsoft SQL-DMO] Error 21268: [SQL-DMO]Row or column specified is outside the range of the specified query result set.

this is what...

Check out this:

http://support.microsoft.com/kb/288577

SQL Server 2000 or SQL Server 2005?

So what is the problem? Are getting an error message?

You said the job failed and asked if we knew why. Based on your original post, no. Read the contents of the file shown, it should tell you...

Did you read the contents of the file?

You may want to look here: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\Model DB Maintenance Plan0.txt

Open up Books Online (from within SSMS, press the {f1} function key). Read about RESTORE HEADERONLY.

Try it. As long as...

What is the configuration of the development server (total server memory, disk drives (raid type or not, etc)? How are the instances configured (min/max memory, etc)?

You might want to take the time to read RESTORE HEADERONLY in BOL.

RESTORE HEADERONLY

FROM disk = 'databasename.bak';

Look up RESTORE HEADERONLY in BOL (Books Online, the SQL Server Help System).

lbrigham (1/5/2010)

---

First post, be kind. 🙂

I'm looking for a better way of doing the below as what I'm doing now results in a table scan and I know there's a...

Thank you for telling us this is a SQL Server 2000 instance. I have asked to have this thread moved to the appropriate SQL Server 2000 forum.