migrate a 600GB of DB from State to State.

Hi All,
What will be the best practise to move a 600 GB of a database from one state
to another, if data needs to be available all the time.
Thanks.
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200603/1Hi
http://vyaskn.tripod.com/moving_sql_server.htm
"Naana via webservertalk.com" <u14055@.uwe> wrote in message
news:5d5785f6d26f1@.uwe...
> Hi All,
> What will be the best practise to move a 600 GB of a database from one
> state
> to another, if data needs to be available all the time.
> Thanks.
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Forum...amming/200603/1|||Please elaborate on what you mean by "from state to state".
From ...
... state of Florida to the state of California ?
... Server01 to Server02 ?
... SQL Server to flat text ?
"Naana via webservertalk.com" <u14055@.uwe> wrote in message
news:5d5785f6d26f1@.uwe...
> Hi All,
> What will be the best practise to move a 600 GB of a database from one
> state
> to another, if data needs to be available all the time.
> Thanks.
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Forum...amming/200603/1

Microsoft.Jet.OLEDB.4.0" has not been registered

I'm trying to import an access database into a sql express database (32 bit system) and get the following error

Msg 7403, Level 16, State 1, Line 1

The OLE DB provider "Microsoft.Jet.OLEDB.4.0" has not been registered.

my script is as follows

SELECT *

FROM OPENDATASOURCE(

'Microsoft.Jet.OLEDB.4.0',

'Data Source="k:\armycwy.mdb";

User ID=Admin;Password='

)...CWAM_ROSTER

Anyone got an idea what is wrong?

TIA

Kevin

I noticed you mentioned 32-bit: is everything 32-bit - i.e. tha machine, Windows, and SQL Express, or is something perhaps 64-bit? We saw similar issues if running 32-bit SQL Server/SQL Express on a 64-bit machine (or vice versa).

What is the Windows version - e.g., XP, Winwdows Server 2000, 2003, etc.?

|||

hi kevin,

pleas try downloading and installing the latest driver

found on this site

http://msdn.microsoft.com/data/mdac/downloads/default.aspx

Joey

Microsoft SQL server Virtual Backup specification

Hi,
My task is to freeze SQL server so that it can be in a consistent state and after my job is done i need to thaw it. I have gone through the VDI specification given by Microsoft SQl server. It is concerned with APIs to third party vendors to take backup of SQL server with or without snapshot. Using that is there a way to do my task ?

Thanks in Advance

Can you tell us a little more about what you're trying to accomplish?

Are you building your own backup app, or what are you accomplishing by freezing the database?

There may be other less disruptive (and easier) methods to use, depending on what you're needing to do.

|||Hi Kevin,
Thanks for the reply.I want to build a backup application. But according to my requirements, i cant install VSS agent on the machine. Is there any way to freeze the SQL server using VDI ?

Microsoft SQL server Virtual Backup specification

Hi,
My task is to freeze SQL server so that it can be in a consistent state and after my job is done i need to thaw it. I have gone through the VDI specification given by Microsoft SQl server. It is concerned with APIs to third party vendors to take backup of SQL server with or without snapshot. Using that is there a way to do my task ?

Thanks in Advance

Can you tell us a little more about what you're trying to accomplish?

Are you building your own backup app, or what are you accomplishing by freezing the database?

There may be other less disruptive (and easier) methods to use, depending on what you're needing to do.

|||Hi Kevin,
Thanks for the reply.I want to build a backup application. But according to my requirements, i cant install VSS agent on the machine. Is there any way to freeze the SQL server using VDI ?

Microsoft SQL server Virtual Backup specification

Hi,
My task is to freeze SQL server so that it can be in a consistent state and after my job is done i need to thaw it. I have gone through the VDI specification given by Microsoft SQl server. It is concerned with APIs to third party vendors to take backup of SQL server with or without snapshot. Using that is there a way to do my task ?

Thanks in Advance

Can you tell us a little more about what you're trying to accomplish?

Are you building your own backup app, or what are you accomplishing by freezing the database?

There may be other less disruptive (and easier) methods to use, depending on what you're needing to do.

|||Hi Kevin,
Thanks for the reply.I want to build a backup application. But according to my requirements, i cant install VSS agent on the machine. Is there any way to freeze the SQL server using VDI ?