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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Backup of SQL2K db to network pc

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
Go to Top of Page

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?
Go to Top of Page

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.
Go to Top of Page

sathyguy
Starting Member

3 Posts

Posted - 2013-05-18 : 21:08:51
so, how can i check that remaining free space size?
Go to Top of Page
   

- Advertisement -