Could be me, but I didn't see any differences between the two strings.

Edit: And yes, there is a way to fix it, I just can't remember it off the...

The RESTORE will not add a new datafile. To do so, you first restore the database, then you ALTER it to add the second datafile.

Has to do with how the string values are actually concatenated. IIRC, straight concatenation, @Var1 = @Var1 + @Var2 for instance, actually copies the data from @Var1 and @Var2...

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';