Hi Jim,
Yes.Go to Enterprise Manager
Select the database--Right Click
--All Tasks
--Backup
Select Database - Complete.
Add Destination ( where the back up file to be taken)
Click Ok.
The Backup is created on file selected for backup
In Options Tab See
SQL SERVER Backup
Which version of SQL Server...SQL2000 has a copy database wizard that can
create a DTS package that you can save and run later.
At 08:54 PM 6/14/2002 -0400, you wrote:
Is there an easy way to back up all the SQL server DB's and
restore them on
a separate Machine?
- j
Is there an easy way to back up all the SQL server DB's and
restore them on a separate Machine?
...
I have SQL server 2K
and thiry + databases ...
I know how to backup each one, but was wondering if there is
a bulk backup of the entire server.
There are a couple of options that
: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 15, 2002 7:01 PM
To: CF-Talk
Subject: RE: OT SQL SERVER Backup
Is there an easy way to back up all the SQL server DB's and
restore them on a separate Machine?
...
I have SQL server 2K
and thiry + databases ...
I know how to backup
Dave Watts wrote:
There are a couple of options that might work for you. If this is a
one-time thing, and you can stop the source database server, you can
simply copy the database and log files to the new server, and use
sp_attach_db to attach each to the new server. snip
Another
Which version of SQL Server...SQL2000 has a copy database wizard that can
create a DTS package that you can save and run later.
At 08:54 PM 6/14/2002 -0400, you wrote:
Is there an easy way to back up all the SQL server DB's and restore them on
a separate Machine?
- j
6 matches
Mail list logo