What Is The Best Way To Clone A Database From Production To Development Environment? We use SQL Server at our company as DBMS. I have a scheduled job working monthly. The job restores every databases on production server to development server at the end of the month but there is insufficient disk issue on the development server. I truncate some big tables which are not important for development teams and shrink all databases after the restore completed. Shrinking databases takes too long time to increase free disk space on development server. Of course, this is not good solution. I need a better or the best solution for the situation. I need your advices. How can i use more efficient method? What would be the best solution?
Omer, It sounds like you are saying that you don't have enough space on the Dev server to restore all of the databases from prod without truncating some tables and shrinking the database to recover space. I'm unsure if you mean above that increasing the size of the drives on the Dev server is an option or not. That part is unclear.
I would push to increase the size of the drives and explaining to your storage team or Windows Admins that you need the space in order to avoid doing the damaging shrink operation as part of your restore process.