|
|
|
Rank: Newbie
Groups: Registered
Joined: 11/6/2009
Posts: 1
|
I have a SQL Server 2000 db on a shared host. My immediate need is to backup the db to my local machine so I can move it to a new (shared) host.
I don't have SQL Management Studio, so I don't know if I can connect through it or not. I can connect an Access .adp which allows me to add and edit tables, views, etc. I also connect to the db directly from my desktop application using a System DSN which is set up on my desktop. Both the .adp and the desktop application connect directly, not by way of the Hosts Web Server.
Is it likely that I will be able to successfully backup the db to my local machine?
Will my new host be able to use the backup to restore my db to a new server?
Is there any possibility that trying to make a backup will destroy my db?
Thanks,
Sup
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 609
|
I installed the software. I setup and successfully tested the connection to the remote server. The database that I want to backup is listed and selected. When I tried to backup my db to my local drive (C:\sqlBackup), it failed. This is the log file:
SUMMARY:
Database Sup_Data: Backup - Failure
DETAILED LOG:
11/10/2009 7:22:10 PM Creating backup of Sup_Data (using scripting)
11/10/2009 7:22:10 PM Scripting to Sup_Data001.sql
11/10/2009 7:22:10 PM Scripting database creation
11/10/2009 7:22:10 PM ERROR: Database scripting failed: An error occured while getting database information. >> System.Data.SqlClient.SqlException: Invalid object name 'sys.databases'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at a.u.o(Stream A_0)
11/10/2009 7:22:10 PM ERROR: Backup of Sup_Data failed: Job failed
11/10/2009 7:22:10 PM Removing temporary folder C:\WINDOWS\TEMP\0atr5bnc.s3a
11/10/2009 7:22:11 PM ERROR: Job finished (With Errors)
Is there a setting or scripting that I can change to make it work, or does this mean that my host has somehow blocked my ability to backup on my own?
Thanks for your help,
Sup
|
|
|
|
Rank: Administration
Groups: Registered
Joined: 8/10/2009
Posts: 143
|
Dear Sup, Sup wrote:Is it likely that I will be able to successfully backup the db to my local machine? You can try to do it. Sup wrote:Will my new host be able to use the backup to restore my db to a new server? Usually, hosters provide users with ability to do it via control panel or etc. Sup wrote:Is there any possibility that trying to make a backup will destroy my db? SQLBackupAndFTP make only backup. I have never seen so SQLBackupAndFTP destroyed my data. However, you should remember that you can erase your data with any careless actions. Sup wrote:
I installed the software. I setup and successfully tested the connection to the remote server. The database that I want to backup is listed and selected. When I tried to backup my db to my local drive (C:\sqlBackup), it failed. This is the log file:
SUMMARY:
Database Sup_Data: Backup - Failure
DETAILED LOG:
11/10/2009 7:22:10 PM Creating backup of Sup_Data (using scripting)
11/10/2009 7:22:10 PM Scripting to Sup_Data001.sql
11/10/2009 7:22:10 PM Scripting database creation
11/10/2009 7:22:10 PM ERROR: Database scripting failed: An error occured while getting database information. >> System.Data.SqlClient.SqlException: Invalid object name 'sys.databases'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
at a.u.o(Stream A_0)
11/10/2009 7:22:10 PM ERROR: Backup of Sup_Data failed: Job failed
11/10/2009 7:22:10 PM Removing temporary folder C:\WINDOWS\TEMP\0atr5bnc.s3a
11/10/2009 7:22:11 PM ERROR: Job finished (With Errors)
Is there a setting or scripting that I can change to make it work, or does this mean that my host has somehow blocked my ability to backup on my own?
Thanks for your help,
Sup
We sorry, but we don't support Scripting database for SQL Server 2000.
|
|
|
|
|
