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 sp1
DB: sql server 2000 sp3
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 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