on 4/10/01 1:54 PM, Bud at [EMAIL PROTECTED] wrote:
It's pretty easy.
Right click on the databases directory in EM, go under the All Tasks
menu and choose Restore Database.
Hey Bud. Thanks. I knew there was an easy way to do this.
Also thank you Adrian Cooper and Adrian Cesana for the
Restore is the best way to do it, but in my experience, that frequently
doesnt work. (Just my luck I guess). So instead you can copy the original
datafiles into your SQL data folder, and use attach instead.
There are details in the Books Online. i don't have that with me right
now, but if I
Look at the DBCC DETACH and DBCC ATTACH in the BOL, this is a nice clean
method of moving an SQL7+ DB...
-Adrian
-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 10:55 AM
To: CF-Talk
Subject: SQL Server database restore
I did my
-Original Message-
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 10, 2001 10:55 AM
I did my development in windows 98 with SQL Server. I have now windows 2000,
with a clean install.
How do I get the SQL Server database which I have backed up from the
You should be able to do it the way you are describing, but you need to tell
SQL server that you are restoring from a device, rather than from a
database.
From the Restore database dialog, there will be three options (on SQL2000 -
I seem to recall that SQL7 was the same):
Restore: (1) Database
On 4/10/01, sebastian palmigiani penned:
I did my development in windows 98 with SQL Server. I have now windows 2000,
with a clean install.
How do I get the SQL Server database which I have backed up from the
win98/SQL Server set up into the new win2000/SQL Server set up?
I have put the backed
6 matches
Mail list logo