As a developer Ihave very minimal knowledge on database backups. Before reaching out to DBA I want to understand few things
1) I need to place a request to create new database on a SQL Server. There is around 540 GB space on this server but the two existing databases on this server already used 500GB space. So what option do we have to create new database?
Is it a simple task to add another drive and allocate some space or use mapped drive? what options can I suggest DBA?
2) Also DBA mentioned that there is no space to take backup on this drive for the existsing database. What option can I suggest for backup incase if we plan to drop one of the database which is not actively used?
View Complete Post