Whats the best way to backup a SQLserver - TechRepublic
General discussion
March 29, 2001 at 01:25 AM
perez6558

Whats the best way to backup a SQLserver

by perez6558 . Updated 25 years, 2 months ago

I have SQL server 7.0 that is the live server. I want to back up my databases that are on that server to my development server which is on a remote network. What is the best way about backing up my databases to that remote server. Sometimes when Iuse Enterprise Manager, I lose primary key information and stuff like that. I’m not sure why. Sometimes, when I transfer tables and stored procedures over, It fails as well and I have no clue why.

This discussion is locked

All Comments