PDA

Click to See Complete Forum and Search --> : ASP site - taking back up of SQL Server database

damon2003
08-12-2009, 01:51 PM
Hi,

I have a site I am migrating to a new server. The current server has a database connection string containing the database name, username and password. It also has SERVER=249724-WWW3 or something like that. Question is how do I access it to take an entire backup of it and save it locally. If I wanted to load it in Enterprise Manager would'nt I need the ip address of the database server, which would be different from the actualy site? Also is ti true only some ISPs allow you to connect to the database remotely?

Thanks a lot.
Kuriyama
08-13-2009, 08:43 AM
Hi,

I have a site I am migrating to a new server. The current server has a database connection string containing the database name, username and password. It also has SERVER=249724-WWW3 or something like that. Question is how do I access it to take an entire backup of it and save it locally. If I wanted to load it in Enterprise Manager would'nt I need the ip address of the database server, which would be different from the actualy site? Also is ti true only some ISPs allow you to connect to the database remotely?

Thanks a lot.

Yes it's true that some hosting providers will force your to remotely connect to a database, in fact this is a best practice. yes you would need to obtain the ip address of the database to connect to it, the SERVER=249724-WWW3 is most likely a DSN entry for your database servers information.