SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Backup of SQL2K db to network pc
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sathyguy
Starting Member

3 Posts

Posted - 05/18/2013 :  02:22:44  Show Profile  Reply with Quote
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

USA
5072 Posts

Posted - 05/18/2013 :  02:40:06  Show Profile  Visit russell's Homepage  Reply with Quote
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 - 05/18/2013 :  05:06:32  Show Profile  Reply with Quote
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

USA
5072 Posts

Posted - 05/18/2013 :  06:41:48  Show Profile  Visit russell's Homepage  Reply with Quote
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 - 05/18/2013 :  21:08:51  Show Profile  Reply with Quote
so, how can i check that remaining free space size?
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000