the sql server is installed in C: drive. Now the C: drive is full (sometimes it going to 0bytes but currently 3 mb free). i cannot reduce any space in c: drive. So that backup is also not working. Now i would like to take a backup in the network pc. Can i take a backup of the db while the users are connected to the database? Now our users(15 users) are all connected to the database and they are working. if i take a backup, will it cause any problem to the server or will there be any disconnection during this backup. and moreover, what is the best way to get this data to a new server. now we have a new server without this database. only sql server 2000 is installed.
thanks...but now the free space in the c: drive is 0 bytes. now the users are also connected and they are entering some records...how its storing when the c: driver is having 0 bytes. Also, can i take a backup in this situation?