Thanks guys ;-).
Urg yaa 6.5 is nightmare but I have to support 2 Production and 1 Dev/Test install of 6.5. Heh you can backup directly to file in 6.5 but for some reason I keep running into issues when I restore.
When I backup to the Device I get a backup that is 100+MB, same database when "dump" to the file goes to only 10MB file. So when I restored the database on other server it cased way too much grief. So I just do Device Backups/Restores; even though it is annoying heh.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN.
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing.
How to ask for help .. Read Best Practices here