can u think of using a pointer to the file instead of storing the hole file in the database, and sotre the file on the file system. this way u...

u want the anti virus to check the attachments before u save them in the database.

if u have one on ur server then am sure it would be scand first,...

have u check the temp files, and u can try for the hiden files also.

this is not good at all..

i dont think there is clean solution.

u have to script out every thing u need. which is stored in the sys databases.

SET @fileName ='C:\Backup\' + @name+'\'+@name + '_' + @fileDate + '.BAK'

any way when truncating the log file the operation want be logged cos u cant log the operations on the log file!!

and u cant drop the log file or delete...

ofcourse if u left the deafult option for the backup the fill will get bigger cos it will use append.

any way u can create to jobs one to run every...

u can create a sub folder on the system with the same name off the database u r backup, then pass the path as dynamic sql.

i dont know the exact number of execution plane its all about memory, but i have a database server with over 50,000 procedure and 300 user, and never had problems...

first off all dont forget to script the loggins, and note ur linked server if any.

second:

about the DTS u have to chagne the source and make it right.

about the Database...

u can use back up restore.. then drop the objects that u dont need..

or do as the others said and for data transfairing u can use:

BCP or normal insert or...

in sql 2000 and 2005 when u use th GUI to script objects like this :

right click the database name then choose script .... what ever, then u choose...

try to use Database tunning advisor it could help, and if u have larg tables u should consider partition tables.

sorry about the feeling that u have,but am sure it wasnt...

yes no problem just make sure about the directories u r installing in.

if think it is better to install every version on a different directory.

i dont think that VM will help, what u will gain from it?