I'm a Sybase DBA on UNIX and I don't know that much about MS SQL Server
2000, but I was just given responsibility for an MS SQL Server 2000 and my
first step was to install MSDE on my desktop and take a backup from the SQL
Server 2000 and try to restore it onto MSDE. so I can play with it.
1. Is it possible to take a backup from SQL Server and load it into MSDE
2. If yes, in Sybase all I have do is create the database on another machine
and load it from the backup file as follow:
Load database dbname from file
This same syntax does not work in MS SQL Server 2000.
I'm going over the online books, but so far I'm very confused. Can anyone
give me a simple summary of whatI need to do.
ThanksHi Germano
In SQL Server 2000, you don't even need to create the db before loading.
What error are you getting when you run the command?
In SQL Server, we use RESTORE instead of LOAD:
RESTORE DATABASE mydb
FROM DISK = 'c:\....
Also, the default is to not recover the database so that tlog backups can be
applied, so you must add WITH RECOVERY when you are done with the restore
operations, to make the db accessible.
Please feel free to ask more questions after thoroughly reading Books
Online. There are some important differences between Sybase backup/restore
and SQL Server backup/restore.
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Germano" <Germano_Silva@.Brown.edu> wrote in message
news:uwf6h1CjDHA.556@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I'm a Sybase DBA on UNIX and I don't know that much about MS SQL Server
> 2000, but I was just given responsibility for an MS SQL Server 2000 and my
> first step was to install MSDE on my desktop and take a backup from the
SQL
> Server 2000 and try to restore it onto MSDE. so I can play with it.
> 1. Is it possible to take a backup from SQL Server and load it into MSDE
> 2. If yes, in Sybase all I have do is create the database on another
machine
> and load it from the backup file as follow:
> Load database dbname from file
> This same syntax does not work in MS SQL Server 2000.
> I'm going over the online books, but so far I'm very confused. Can anyone
> give me a simple summary of whatI need to do.
> Thanks
>
>|||This is a multi-part message in MIME format.
--=_NextPart_000_01F0_01C38C0D.8D14F410
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Check out RESTORE DATABASE in the BOL. Also, beware of logins being out =of synch with users in the database. You can correct this with =sp_change_users_login.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Germano" <Germano_Silva@.Brown.edu> wrote in message =news:uwf6h1CjDHA.556@.TK2MSFTNGP11.phx.gbl...
Hi,
I'm a Sybase DBA on UNIX and I don't know that much about MS SQL Server
2000, but I was just given responsibility for an MS SQL Server 2000 and =my
first step was to install MSDE on my desktop and take a backup from the =SQL
Server 2000 and try to restore it onto MSDE. so I can play with it.
1. Is it possible to take a backup from SQL Server and load it into MSDE
2. If yes, in Sybase all I have do is create the database on another =machine
and load it from the backup file as follow:
Load database dbname from file
This same syntax does not work in MS SQL Server 2000.
I'm going over the online books, but so far I'm very confused. Can =anyone
give me a simple summary of whatI need to do.
Thanks
--=_NextPart_000_01F0_01C38C0D.8D14F410
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Check out RESTORE DATABASE in the =BOL. Also, beware of logins being out of synch with users in the database. =You can correct this with sp_change_users_login.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Germano"
--=_NextPart_000_01F0_01C38C0D.8D14F410--|||Check out this link ->
http://support.microsoft.com/default.aspx?scid=kb;en-
us;307775
You can move the backup file to the destination machine
and use Enterprise Manager to restore it to the new
location. Just highlight the Databases node and select All
Tasks and select Restore Database. Follow the wizard after
that.
Edgardo Valdez
MCSD, MCDBA, MCSE, MCP+I
http://www.edgardovaldez.us/
>--Original Message--
>Hi,
>I'm a Sybase DBA on UNIX and I don't know that much about
MS SQL Server
>2000, but I was just given responsibility for an MS SQL
Server 2000 and my
>first step was to install MSDE on my desktop and take a
backup from the SQL
>Server 2000 and try to restore it onto MSDE. so I can
play with it.
>1. Is it possible to take a backup from SQL Server and
load it into MSDE
>2. If yes, in Sybase all I have do is create the database
on another machine
>and load it from the backup file as follow:
> Load database dbname from file
>This same syntax does not work in MS SQL Server 2000.
>I'm going over the online books, but so far I'm very
confused. Can anyone
>give me a simple summary of whatI need to do.
>Thanks
>
>.
>|||That did not work. Here's the error
D:\DV Backup>osql -Sdev340\NetSDK -E
1> use master
2> go
1> restore database DialVision from disk = 'd:\Dv
Backup\Dialvision_db_200309260300.bak'
2> go
Msg 5105, Level 16, State 2, Server DEV340\NETSDK, Line 1
Device activation error. The physical file name 'e:\Program Files\Microsoft
SQL
Server\mssql\Data\dialvision_data.mdf' may be incorrect.
Msg 3156, Level 16, State 1, Server DEV340\NETSDK, Line 1
File 'DVision_Data' cannot be restored to 'e:\Program Files\Microsoft SQL
Server\mssql\Data\dialvision_data.mdf'. Use WITH MOVE to identify a valid
location for the file.
Msg 5105, Level 16, State 2, Server DEV340\NETSDK, Line 1
Device activation error. The physical file name 'e:\Program Files\Microsoft
SQL
Server\mssql\Data\dialvision_log.ldf' may be incorrect.
Msg 3156, Level 16, State 1, Server DEV340\NETSDK, Line 1
File 'DVision_Log' cannot be restored to 'e:\Program Files\Microsoft SQL
Server\mssql\Data\dialvision_log.ldf'.
Use WITH MOVE to identify a valid location for the file.
Msg 3013, Level 16, State 1, Server DEV340\NETSDK, Line 1
RESTORE DATABASE is terminating abnormally.
1>
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:OovDu6CjDHA.2492@.TK2MSFTNGP12.phx.gbl...
> Hi Germano
> In SQL Server 2000, you don't even need to create the db before loading.
> What error are you getting when you run the command?
> In SQL Server, we use RESTORE instead of LOAD:
> RESTORE DATABASE mydb
> FROM DISK = 'c:\....
> Also, the default is to not recover the database so that tlog backups can
be
> applied, so you must add WITH RECOVERY when you are done with the restore
> operations, to make the db accessible.
> Please feel free to ask more questions after thoroughly reading Books
> Online. There are some important differences between Sybase backup/restore
> and SQL Server backup/restore.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Germano" <Germano_Silva@.Brown.edu> wrote in message
> news:uwf6h1CjDHA.556@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > I'm a Sybase DBA on UNIX and I don't know that much about MS SQL Server
> > 2000, but I was just given responsibility for an MS SQL Server 2000 and
my
> > first step was to install MSDE on my desktop and take a backup from the
> SQL
> > Server 2000 and try to restore it onto MSDE. so I can play with it.
> >
> > 1. Is it possible to take a backup from SQL Server and load it into MSDE
> > 2. If yes, in Sybase all I have do is create the database on another
> machine
> > and load it from the backup file as follow:
> >
> > Load database dbname from file
> >
> > This same syntax does not work in MS SQL Server 2000.
> >
> > I'm going over the online books, but so far I'm very confused. Can
anyone
> > give me a simple summary of whatI need to do.
> >
> > Thanks
> >
> >
> >
>|||Here's thesyntax that worked:
restore filelistonly
from disk = 'd:\Dv Backup\Dialvision_db_200309260300.bak'
restore database myDV
from disk = 'd:\Dv Backup\Dialvision_db_200309260300.bak'
with move 'DVision_data' to 'd:\DV Backup\myDV.mdf',
move 'DVision_log' to 'd:\DV Backup\myDV.ldf'
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:OovDu6CjDHA.2492@.TK2MSFTNGP12.phx.gbl...
> Hi Germano
> In SQL Server 2000, you don't even need to create the db before loading.
> What error are you getting when you run the command?
> In SQL Server, we use RESTORE instead of LOAD:
> RESTORE DATABASE mydb
> FROM DISK = 'c:\....
> Also, the default is to not recover the database so that tlog backups can
be
> applied, so you must add WITH RECOVERY when you are done with the restore
> operations, to make the db accessible.
> Please feel free to ask more questions after thoroughly reading Books
> Online. There are some important differences between Sybase backup/restore
> and SQL Server backup/restore.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Germano" <Germano_Silva@.Brown.edu> wrote in message
> news:uwf6h1CjDHA.556@.TK2MSFTNGP11.phx.gbl...
> > Hi,
> >
> > I'm a Sybase DBA on UNIX and I don't know that much about MS SQL Server
> > 2000, but I was just given responsibility for an MS SQL Server 2000 and
my
> > first step was to install MSDE on my desktop and take a backup from the
> SQL
> > Server 2000 and try to restore it onto MSDE. so I can play with it.
> >
> > 1. Is it possible to take a backup from SQL Server and load it into MSDE
> > 2. If yes, in Sybase all I have do is create the database on another
> machine
> > and load it from the backup file as follow:
> >
> > Load database dbname from file
> >
> > This same syntax does not work in MS SQL Server 2000.
> >
> > I'm going over the online books, but so far I'm very confused. Can
anyone
> > give me a simple summary of whatI need to do.
> >
> > Thanks
> >
> >
> >
>
No comments:
Post a Comment