Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004

    Unanswered: Data files in Flash Drive

    Hi friends,
    i want to know something abt sql server installation and database properties as under.
    1) how much disk space reqd by multiuser sqlserver 2000 db to install ?
    2) is it possible to install sql 2K on Flash Drive ( gen connect at USB) ?
    3) When v create a database user Enterprise Manager , which files created by database ?
    4) If i Know datafiles name of a database e.g. pubs , and if v copied on cd and paste on other system which has sql 2K install , does those database works ?
    5) is it possible to create database on flash drive ?

    thanx in advance.

  2. #2
    Join Date
    Nov 2002
    Come on...are these trick questions?

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Jan 2003
    Provided Answers: 17
    I suppose it could be done, but you would have to be very sure that you properly detach the database before someone goes and unplugs the USB drive. I think you would set yourself up for a heck of a lot more user errors than SQL Server errors this way.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts