SQL server7 interprize manager - how to backup?
Hi there Could anyone refer me to a good resource on SQL server interprize manager.
or
explain to me the process I need to undergoe to backup my db on the SQL server of my website - onto the SQL server I have at home so that I can update the database - or is there perhaps a better way to update the db?
Please help me understand how to do this, thanks
Andrew
Peter J. Boettcher posted this at 17:03 — 4th December 2000.
They have: 812 posts
Joined: Feb 2000
Andrew,
It's pretty simple to copy data from one SQL Server to another using Enterprise Manager (EM). Simply do a right-click on the database name in EM, you'll get a sub-menu, select All-tasks and then export data. Then simply follow the directions, it pretty self explanatory. I'm using SQL 2000 so the menu's in SQL 7 might be a little different, just look for "export data".
As for updating the database, why don't you update it on the Website? You would save yourself a lot of time, unless you have a test/production setup.
PJ | Are we there yet?
pjboettcher.com
andy4444 posted this at 23:12 — 4th December 2000.
They have: 20 posts
Joined: Oct 2000
Thanks for that - is it difficult to make the connection between the DB's - I don't have the EM in front of me - it should be installed within the week.
Do you know if this connection it makes it using FTP (port 21)to transfer the db over the net, or will I run into problems with my companies strict firewall?
Thanks again mate
Peter J. Boettcher posted this at 13:50 — 5th December 2000.
They have: 812 posts
Joined: Feb 2000
Andy,
The connection EM uses to connect to SQL databases goes over port 1433 (by default) and can use many different network libraries but it's best to stick with TCP/IP.
Just setup the firewall to let requests from your computer go through port 1433 and everything should be fine.
PJ | Are we there yet?
pjboettcher.com
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.