database refresh???

#1

Hi,

I need to refresh the database1 in TEST. In an other word it has to be
restored. I have a database file database1.db. Do you know how a can proceed
from Enterprise Manager?

Thanks

Barb

#2

It sounds like you are trying to upgrade an access db to SQL Server. Is
that true?

If it is, then the easiest way to do this is to run the Upsize Advisor.
http://support.microsoft.com/kb/237980

thanks,

--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
Tech Blog - www.technologyis.com
*/

"Barb" <Barb (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I need to refresh the database1 in TEST. In an other word it has to
be
restored. I have a database file database1.db. Do you know how a can
proceed
from Enterprise Manager?

Thanks

Barb

#3

Is the file you have a valid SQL Server backup file?

..db is not one of the standard SQL Server extensions...

Kevin3NF

"Barb" <Barb (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

I need to refresh the database1 in TEST. In an other word it has to
be
restored. I have a database file database1.db. Do you know how a can
proceed
from Enterprise Manager?

Thanks

Barb

#4

Hi,

it's a .BAK sorry.

"news.microsoft.com" wrote:

Quote:

Is the file you have a valid SQL Server backup file?

..db is not one of the standard SQL Server extensions...

Kevin3NF

"Barb" <Barb (AT) discussions (DOT) microsoft.com> wrote in message
news:E703D020-04BC-4AC2-8774-2E0F764E5789 (AT) microsoft (DOT) com...
Hi,

I need to refresh the database1 in TEST. In an other word it has to
be
restored. I have a database file database1.db. Do you know how a can
proceed
from Enterprise Manager?

Thanks

Barb

#5

If you want to do it through enterprise manager or SQL Management Studio you
can follow these instructions from Microsoft.

http://support.microsoft.com/kb/314546

--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
Tech Blog - www.technologyis.com
*/

"Barb" <Barb (AT) discussions (DOT) microsoft.com> wrote

Quote:

Hi,

it's a .BAK sorry.

"news.microsoft.com" wrote:

Is the file you have a valid SQL Server backup file?

..db is not one of the standard SQL Server extensions...

Kevin3NF

"Barb" <Barb (AT) discussions (DOT) microsoft.com> wrote in message
news:E703D020-04BC-4AC2-8774-2E0F764E5789 (AT) microsoft (DOT) com...
Hi,

I need to refresh the database1 in TEST. In an other word it has
to
be
restored. I have a database file database1.db. Do you know how a can
proceed
from Enterprise Manager?

Thanks

Barb

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

database refresh???

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

database refresh??? - 10-23-2006 , 02:48 PM

Re: database refresh??? - 10-23-2006 , 11:01 PM

Re: database refresh??? - 10-24-2006 , 08:11 AM

Re: database refresh??? - 10-24-2006 , 01:59 PM

Re: database refresh??? - 10-24-2006 , 07:30 PM