| Author |
Topic |
|
assh11
Starting Member
7 Posts |
 Posted - 2010-04-22 : 17:00:44
|
| Hello,I am trying to backup SQL server 2000 database which is in a virtual PC to a mapped driver which is a main system. I am performing complete database backup through SQL Server Enterprise Manager.I have scheduled it to occur every day. The size of the database is 121338 MB. The database backup is happening on the scheduled time but it is not doing complete backup. If I check the size of the backup file it is 4,194, 304 kb.After the backup I am getting following error"The data has been lost. This error may be caused by a failure of your computer hardware or network connection. Please try to save this file elsewhere."If anyone knows how to solve this problem please let me know. Your help is greatly appreciated.Thank you,Assh |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
assh11
Starting Member
7 Posts |
Posted - 2010-04-22 : 17:25:02
|
| Hello Tara kizer,Thank you for your reply. I will check on the network connection problem.Thank you,Assh |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
assh11
Starting Member
7 Posts |
Posted - 2010-04-23 : 11:54:04
|
| Hi,I tried to take SQL server 2000 database backup on the local drive where SQL Server 2000 instance is running using SQL Server Enterprise Manager. It was not successful since the database size is 121339.48 MB and local drives C or D does not have enough space to store the backup database. Could anyone please tell me what are the best methods to take backup in this situation? Thank you,Assh |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
assh11
Starting Member
7 Posts |
Posted - 2010-04-23 : 13:10:08
|
| Thank you, I will look into the options you have mentioned. |
|
|
|
assh11
Starting Member
7 Posts |
Posted - 2010-04-23 : 14:49:29
|
| Hello Tara Kizer,Is there a way to attach and detach database using script and then copying into some disk location? I want to schedule this job to execute every day. If it is possible then do you have script to do that and how will it work? Please let me know if I am in the right direction.Thank you,Assh |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
SQL Server 2000 database backup problem