that has never had the database on it?
We lost a development server and reinstalled SQL Server I
have user database backups but no system database
backups. When I attempt a restore I cannot see the .bak
file that I would like to restore. I thought that I
could create a new database with the same name and then
restore the .bak to get the database back. is this an
incorrect procedure?
When you restore, choose "From Device" and locate the bak
file.
>--Original Message--
>Can a user database .bak be restored to another server
>that has never had the database on it?
>We lost a development server and reinstalled SQL Server
I
>have user database backups but no system database
>backups. When I attempt a restore I cannot see the .bak
>file that I would like to restore. I thought that I
>could create a new database with the same name and then
>restore the .bak to get the database back. is this an
>incorrect procedure?
>
>.
>
|||>>Can a user database .bak be restored to another server that has never had
the database on it?
Yes.
[vbcol=seagreen]
restore
because it (the backup) was recorded on the original server.
You can restore with or without the database created first. Look for
RESTORE DATABASE in BOL.
"Jim Abel" <jim.abel@.lmco.com> wrote in message
news:246d01c427d7$6392e640$a601280a@.phx.gbl...
> Can a user database .bak be restored to another server
> that has never had the database on it?
> We lost a development server and reinstalled SQL Server I
> have user database backups but no system database
> backups. When I attempt a restore I cannot see the .bak
> file that I would like to restore. I thought that I
> could create a new database with the same name and then
> restore the .bak to get the database back. is this an
> incorrect procedure?
>
|||Hi Jim,
Thanks for posting in the Newsgroup. Assuming the database you want to
restore your "c:\db.bak" file into a database named "newdb" and you are
using SQL Server 2000
You could try to restore it with SQL Server Enterprise Manager by following
steps
1.Open SQL Server Enterprise Manager and select the instance and "newdb"
2.Right Click "newdb" -> All Tasks -> Restore database
3.Select "From device" in General Tab
4.Click Select DevicesX
5.Add the file you want in the pop dialog
6.Click OK and you will see Restore Process Dialog and then you will be
notified that you have successfully restored your database.
Also, you could try to restore it with Query Analyzer by following steps:
1.Open Query Analyzer, Login as sa (or whatever have RESTORE privilege)
2.type the T-SQL
RESTORE DATABASE newdb from disk='c:\db.bak'
3. you will get the result like
RESTORE DATABASE successfully processed 113 pages in 0.370 seconds (2.485
MB/sec).
Bottom line - have a good backup strategy.
Please feel free to post in the group if this solves your problem or if you
would like further help. We are here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Support
************************************************** *********
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
|||Thanks for the quick reply. The restore went well.[vbcol=seagreen]
>--Original Message--
that has never had[vbcol=seagreen]
>the database on it?
>Yes.
that I would like to
>restore
>because it (the backup) was recorded on the original
server.
>You can restore with or without the database created
first. Look for[vbcol=seagreen]
>RESTORE DATABASE in BOL.
>
>"Jim Abel" <jim.abel@.lmco.com> wrote in message
>news:246d01c427d7$6392e640$a601280a@.phx.gbl...
Server I
>
>.
>
|||Thanks for the quick reply. The restore went well.
>--Original Message--
>When you restore, choose "From Device" and locate the
bak
>file.
>I
>.
>
|||Thanks for the quick reply. The restore went well.
>--Original Message--
>Hi Jim,
>Thanks for posting in the Newsgroup. Assuming the=20
database you want to=20
>restore your "c:\db.bak" file into a database=20
named "newdb" and you are=20
>using SQL Server 2000
>You could try to restore it with SQL Server Enterprise=20
Manager by following=20
>steps
>1.Open SQL Server Enterprise Manager and select the=20
instance and "newdb"
>2.Right Click "newdb" -> All Tasks -> Restore=20
database
>3.Select "From device" in General Tab
>4.Click Select Devices=A1=AD
>5.Add the file you want in the pop dialog
>6.Click OK and you will see Restore Process Dialog=20
and then you will be=20
>notified that you have successfully restored your=20
database.
>
>Also, you could try to restore it with Query Analyzer by=20
following steps:
>1.Open Query Analyzer, Login as sa (or whatever=20
have RESTORE privilege)
>2.type the T-SQL
>RESTORE DATABASE newdb from disk=3D'c:\db.bak'
>3. you will get the result like=20
>RESTORE DATABASE successfully processed 113 pages in=20
0.370 seconds (2.485=20
>MB/sec).
>
>Bottom line - have a good backup strategy.
>Please feel free to post in the group if this solves=20
your problem or if you=20
>would like further help. We are here to be of assistance!
>Sincerely yours,
>Michael Cheng
>Microsoft Online Support
>************************************************* ********
**
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and=20
confers no rights.
>Please reply to newsgroups only, many thanks.
>.
>
|||I also need to "copy" one of our databases to a different server. Can I only backup and restore the one user database? Do I have to do anything with msdb, master, model.etc? Please advise.
|||You can backup and restore the one user database to another
server. It's done frequently. You still need to be aware of
anything configured or setup on the source server and issues
you could run into related to this. Examples of some things
to watch out for would be users in the database that don't
exist on the destination server, using linked servers,
cross-database stored procedures, etc.
-Sue
On Tue, 25 May 2004 17:01:04 -0700, "Ling"
<anonymous@.discussions.microsoft.com> wrote:
>I also need to "copy" one of our databases to a different server. Can I only backup and restore the one user database? Do I have to do anything with msdb, master, model.etc? Please advise.
|||Hi,
Thank you for using MSDN Newsgroup!
It is highly appreciated that you should post your own questions as a new
thread, which, I believe, will get us closer and quicker to the resolutions
In general, we need not do anything with other databases such as msdb,
master etc. However, I am not sure your detailed requirements. You are
welcome to raise your issue to the newsgroup by a new post
Thank you for your patience and cooperation.
Sincerely yours,
Michael Cheng
Microsoft Online Support
************************************************** *********
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks.
No comments:
Post a Comment