moving project 2010 draft data and log file


  • Hi All,

    i got a project server 2010 draft data and log file that is grovn big and i want to move the files to datadrive.

    can i just dtétact the database, move the files and attach the database again using sql server manager? or do i need to be avware of the other databases or stop users to access the solution while doing moving the files?



    Thursday, November 8, 2018 9:40 AM

All replies

  • The easiest thing to do is manage your SQL server databases.

    1) Shutdown SharePoint Farm

    2) Backup both the content and log databases.  Its required when shrinking database and cleaning log files

    3) Shrink databases and log files.   You will then get a lot of space back.

    or if you are carefully

    a) dismount database from SQL server

    b) delete the log file

    c) mount database again and SQL will create a new log file.

    Michael Wharton, Project MVP, MBA, PMP and a Great Guy <br/> Website <br/> Blog contains my field notes and SQL queries

    Friday, November 9, 2018 3:50 AM
  • i thought about shrinking log and data files im making full backups so shirinking log files should not be a problem but not sure about shrinking datafiles... how much can i shrink that file its more than 20 gb now log file is about 1,5 gb oi saw something about shrinking data file could slow down the database?...
    Tuesday, November 20, 2018 8:35 AM