Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sathyguy
Starting Member
3 Posts |
 Posted - 2013-05-18 : 02:22:44
|
| Friends,OS: windows 2003 sp1DB: sql server 2000 sp3the 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 and waiting for somebody's help. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-05-18 : 02:40:06
|
| Backup will not significantly affect connected users. You need to do this as soon as possible,Best way to get data to new server is to restore the backup to it |
 |
|
|
sathyguy
Starting Member
3 Posts |
Posted - 2013-05-18 : 05:06:32
|
| 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? |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2013-05-18 : 06:41:48
|
| There is still some free space in the database. You need find some space somewhere though and soon.Yes, you should be able to take a backup, but not locally. |
|
|
|
sathyguy
Starting Member
3 Posts |
Posted - 2013-05-18 : 21:08:51
|
| so, how can i check that remaining free space size? |
|
|
|
|
|
|
Backup of SQL2K db to network pc