• Lowell,

    I am not usuing raw dbnames but using a cursor to loop through all the dbs and back them up to the folder location. There is no space issue at all. I changed the code a lil bit ( commented out the sp_ExecuteSql statement that executes the dynamic sql for backing up the dbs and added a print statement) Then it gives this warning

    Warning! The maximum key length is 900 bytes. The index 'PK__#630D628__5F9AD70964F5AAFC' has maximum length of 2000 bytes. For some combination of large values, the insert/update operation will fail.

    But it does work..!! Donno if this might be helpful

    --Pra:-):-)--------------------------------------------------------------------------------