Showing posts with label program. Show all posts
Showing posts with label program. Show all posts

Wednesday, March 28, 2012

I/O error on backup or restore restart-checkpoint file

Does any of you know what this is about:
"I/O error on backup or restore restart-checkpoint
file 'E:\Program Files\Microsoft SQL
Server\MSSQL\backup\Domain1.ckp'. Operating system error 3
(error not found). The statement is proceeding but is non-
restartable."
I get an error code 18272 (cant find it in BOL).
Note: Domain1 is the name of a specific database on my
server.
The directory 'E:\Program Files\Microsoft SQL
Server\MSSQL\backup' have been deleted so it is no wonder
that it can't either find nor create a file in that
directory.
The error was raised during a restore of the Domain1
database (the restore completed successfuly). I have a job
that kills every connection to the Domain1 database
(except it's own connection) for the database to be
restorable.
What setting must be set for SQL Server not to use this
directory for this purpose?
Note: backups (both data og log) are written just fine to
another directory.
Yours truly
Jakob Pedersen"Jakob Pedersen" <anonymous@.discussions.microsoft.com> wrote in message
news:171201c3e051$27d725d0$a301280a@.phx.gbl...
quote:

> Does any of you know what this is about :
> "I/O error on backup or restore restart-checkpoint
> file 'E:\Program Files\Microsoft SQL
> Server\MSSQL\backup\Domain1.ckp'. Operating system error 3
> (error not found). The statement is proceeding but is non-
> restartable."
> I get an error code 18272 (cant find it in BOL).
> Note: Domain1 is the name of a specific database on my
> server.
> The directory 'E:\Program Files\Microsoft SQL
> Server\MSSQL\backup' have been deleted so it is no wonder
> that it can't either find nor create a file in that
> directory.
> The error was raised during a restore of the Domain1
> database (the restore completed successfuly). I have a job
> that kills every connection to the Domain1 database
> (except it's own connection) for the database to be
> restorable.

Are you sure the restore was successful? It sounds like something did not
work quite right... do you still have the syntax you used for the restore?
quote:

> What setting must be set for SQL Server not to use this
> directory for this purpose?

It really depends on how you performed the restore here...
quote:

> Note: backups (both data og log) are written just fine to
> another directory.

During the restore? I'm not sure what you mean here.
Steve|||> "Jakob Pedersen" <anonymous@.discussions.microsoft.com> wrote in message
quote:

> news:171201c3e051$27d725d0$a301280a@.phx.gbl...
>

Are you sure the restore was successful? It sounds like something did not
work quite right... do you still have the syntax you used for the restore?
quote:

>
It really depends on how you performed the restore here...
[QUOTE]
During the restore? I'm not sure what you mean here.
Steve
[QUOTE]
>

Monday, March 19, 2012

i want help to build a application that will load data in msolap

Hi ,
i am new to msolap , i want to make an application that will update data or
insert data in msolap.
Any link , help ,book,sample program will be helpful .
thanks in advance .
kjangirHere are 2 books
Microsoft(r) SQL Server(tm) 2000 Analysis Services Step by Step
(http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2)
Professional SQL Server 2000 Data Warehousing with Analysis Services
(http://www.amazon.com/exec/obidos/A...link%5Fcode=xm2)
Also take a look at the MS OLAP newsgroup
(http://groups.google.com/group/micr...sqlserver.olap)
and the MS Datawarehouse newsgroup
(http://groups.google.com/group/micr...r.datawarehouse)
http://sqlservercode.blogspot.com/|||Which version of Analysis Services: 2000 or 2005?
When you say "update data or insert data", are you referring to:
.. loading source data into SQL Server fact tables
.. processing the dimensions/cubes from the fact tables
.. changing the underlying values stored in the cubes (write-back) ?
Best Practices for Using DTS for Business Intelligence Solutions
http://msdn.microsoft.com/library/d...ntbpwithdts.asp
Loading Data into the Data Warehouse Database
http://msdn.microsoft.com/library/d...r />
_88it.asp
Building and Processing Cubes
http://msdn.microsoft.com/library/e...>
ack_9xsx.asp
"kuldeep kumar" <kuldeepkumar@.discussions.microsoft.com> wrote in message
news:A19E2425-397D-419C-88C2-273F50C1801B@.microsoft.com...
> Hi ,
> i am new to msolap , i want to make an application that will update data
> or
> insert data in msolap.
> Any link , help ,book,sample program will be helpful .
> thanks in advance .
> kjangir

Wednesday, March 7, 2012

i need to connect python to sql2005

hi
i need to connect
a small program written in Python
to a SqlServer 2005 database
how con i do it ?
can anyone link me to a resource ?
thanks
You should be able to connect with ODBC jsut like any other language. I
would start by looking at the Python web site:
http://www.python.org/
but a simple google search for python odbc gives a lot of hits. It's amazing
what a few keystrokes can buy you these days.
Andrew J. Kelly SQL MVP
"keyser soze" <bajopalabra@.hotmail.com> wrote in message
news:O93RJ1YbHHA.4656@.TK2MSFTNGP03.phx.gbl...
> hi
> i need to connect
> a small program written in Python
> to a SqlServer 2005 database
> how con i do it ?
> can anyone link me to a resource ?
> thanks
>
|||of course, Andrew
i googled that...
( does exist anybody
that don't find answers on internet first ?! :-)
i promisse i did it,
what i found is an old adodbapi
developed near 2003, that is
before sql2005 being released
i wonder if there is other ways
thanks & regards!
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
news:OrwyjTabHHA.4544@.TK2MSFTNGP03.phx.gbl...
> You should be able to connect with ODBC jsut like any other language. I
> would start by looking at the Python web site:
> http://www.python.org/
> but a simple google search for python odbc gives a lot of hits. It's
amazing
> what a few keystrokes can buy you these days.
> --
> Andrew J. Kelly SQL MVP
> "keyser soze" <bajopalabra@.hotmail.com> wrote in message
> news:O93RJ1YbHHA.4656@.TK2MSFTNGP03.phx.gbl...
>
|||If you google for "python odbc sql 2005" the very first hit is a 3rd party
that has 2005 drivers. There are several other links that appear useful as
well. Hopefully one of those will do the trick.
Andrew J. Kelly SQL MVP
"keyser soze" <bajopalabra@.hotmail.com> wrote in message
news:un3HEf6bHHA.260@.TK2MSFTNGP02.phx.gbl...
> of course, Andrew
> i googled that...
> ( does exist anybody
> that don't find answers on internet first ?! :-)
> i promisse i did it,
> what i found is an old adodbapi
> developed near 2003, that is
> before sql2005 being released
>
> i wonder if there is other ways
> thanks & regards!
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
> news:OrwyjTabHHA.4544@.TK2MSFTNGP03.phx.gbl...
> amazing
>
|||well, i'm looking for something """free"""
but you are right,
i'll search in depth
thanks
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
news:%23G2y$I9bHHA.2316@.TK2MSFTNGP04.phx.gbl...
> If you google for "python odbc sql 2005" the very first hit is a 3rd party
> that has 2005 drivers. There are several other links that appear useful as
> well. Hopefully one of those will do the trick.
> --
> Andrew J. Kelly SQL MVP
> "keyser soze" <bajopalabra@.hotmail.com> wrote in message
> news:un3HEf6bHHA.260@.TK2MSFTNGP02.phx.gbl...
>
|||OK well that may narrow the search down a bit.
Andrew J. Kelly SQL MVP
"keyser soze" <bajopalabra@.hotmail.com> wrote in message
news:Oz$N3X9bHHA.1216@.TK2MSFTNGP03.phx.gbl...
> well, i'm looking for something """free"""
> but you are right,
> i'll search in depth
> thanks
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
> news:%23G2y$I9bHHA.2316@.TK2MSFTNGP04.phx.gbl...
>
|||I just googled it and found a free one on the first hit - a
download from sourceforge:
About pymssql
This module provides access to Microsoft SQL Servers from
Python scripts. It's the most efficient method of accessing
MS SQL Server's data from Python scripts.
http://pymssql.sourceforge.net/
And in the first few hits there was this:
Microsoft SQL Server Express / Python HOWTO
http://www.time-travellers.org/shane/howtos/MS-SQL-Express-Python-HOWTO.html
-Sue
On Mon, 26 Mar 2007 15:50:43 -0300, "keyser soze"
<bajopalabra@.hotmail.com> wrote:

>well, i'm looking for something """free"""
>but you are right,
>i'll search in depth
>thanks
>"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
>news:%23G2y$I9bHHA.2316@.TK2MSFTNGP04.phx.gbl...
>
|||come on, hit me...
anyway, thanks both
for reply with respect
you are very kind
|<aiser Soze
"Sue Hoegemeier" <Sue_H@.nomail.please> escribi en el mensaje
news:jfmg03toi97nkhslost93k5ir0s5ina8jc@.4ax.com...
> I just googled it and found a free one on the first hit - a
> download from sourceforge:
> About pymssql
> This module provides access to Microsoft SQL Servers from
> Python scripts. It's the most efficient method of accessing
> MS SQL Server's data from Python scripts.
> http://pymssql.sourceforge.net/
> And in the first few hits there was this:
> Microsoft SQL Server Express / Python HOWTO
>
http://www.time-travellers.org/shane/howtos/MS-SQL-Express-Python-HOWTO.html[vbcol=seagreen]
> -Sue
> On Mon, 26 Mar 2007 15:50:43 -0300, "keyser soze"
> <bajopalabra@.hotmail.com> wrote:
party[vbcol=seagreen]
as[vbcol=seagreen]
mensaje[vbcol=seagreen]
language. I
>

i need to connect python to sql2005

hi
i need to connect
a small program written in Python
to a SqlServer 2005 database
how con i do it ?
can anyone link me to a resource ?
thanksYou should be able to connect with ODBC jsut like any other language. I
would start by looking at the Python web site:
http://www.python.org/
but a simple google search for Python odbc gives a lot of hits. It's amazing
what a few keystrokes can buy you these days.
Andrew J. Kelly SQL MVP
"keyser soze" <bajopalabra@.hotmail.com> wrote in message
news:O93RJ1YbHHA.4656@.TK2MSFTNGP03.phx.gbl...
> hi
> i need to connect
> a small program written in Python
> to a SqlServer 2005 database
> how con i do it ?
> can anyone link me to a resource ?
> thanks
>|||of course, Andrew
i googled that...
( does exist anybody
that don't find answers on internet first ?! :-)
i promisse i did it,
what i found is an old adodbapi
developed near 2003, that is
before sql2005 being released
i wonder if there is other ways
thanks & regards!
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
news:OrwyjTabHHA.4544@.TK2MSFTNGP03.phx.gbl...
> You should be able to connect with ODBC jsut like any other language. I
> would start by looking at the Python web site:
> http://www.python.org/
> but a simple google search for Python odbc gives a lot of hits. It's
amazing
> what a few keystrokes can buy you these days.
> --
> Andrew J. Kelly SQL MVP
> "keyser soze" <bajopalabra@.hotmail.com> wrote in message
> news:O93RJ1YbHHA.4656@.TK2MSFTNGP03.phx.gbl...
>|||If you google for "python odbc sql 2005" the very first hit is a 3rd party
that has 2005 drivers. There are several other links that appear useful as
well. Hopefully one of those will do the trick.
Andrew J. Kelly SQL MVP
"keyser soze" <bajopalabra@.hotmail.com> wrote in message
news:un3HEf6bHHA.260@.TK2MSFTNGP02.phx.gbl...
> of course, Andrew
> i googled that...
> ( does exist anybody
> that don't find answers on internet first ?! :-)
> i promisse i did it,
> what i found is an old adodbapi
> developed near 2003, that is
> before sql2005 being released
>
> i wonder if there is other ways
> thanks & regards!
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
> news:OrwyjTabHHA.4544@.TK2MSFTNGP03.phx.gbl...
> amazing
>|||well, i'm looking for something """free"""
but you are right,
i'll search in depth
thanks
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
news:%23G2y$I9bHHA.2316@.TK2MSFTNGP04.phx.gbl...
> If you google for "python odbc sql 2005" the very first hit is a 3rd party
> that has 2005 drivers. There are several other links that appear useful as
> well. Hopefully one of those will do the trick.
> --
> Andrew J. Kelly SQL MVP
> "keyser soze" <bajopalabra@.hotmail.com> wrote in message
> news:un3HEf6bHHA.260@.TK2MSFTNGP02.phx.gbl...
>|||OK well that may narrow the search down a bit.
Andrew J. Kelly SQL MVP
"keyser soze" <bajopalabra@.hotmail.com> wrote in message
news:Oz$N3X9bHHA.1216@.TK2MSFTNGP03.phx.gbl...
> well, i'm looking for something """free"""
> but you are right,
> i'll search in depth
> thanks
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
> news:%23G2y$I9bHHA.2316@.TK2MSFTNGP04.phx.gbl...
>|||I just googled it and found a free one on the first hit - a
download from sourceforge:
About pymssql
This module provides access to Microsoft SQL Servers from
Python scripts. It's the most efficient method of accessing
MS SQL Server's data from Python scripts.
http://pymssql.sourceforge.net/
And in the first few hits there was this:
Microsoft SQL Server Express / Python HOWTO
http://www.time-travellers.org/shan...thon-HOWTO.html
-Sue
On Mon, 26 Mar 2007 15:50:43 -0300, "keyser soze"
<bajopalabra@.hotmail.com> wrote:

>well, i'm looking for something """free"""
>but you are right,
>i'll search in depth
>thanks
>"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> escribi en el mensaje
>news:%23G2y$I9bHHA.2316@.TK2MSFTNGP04.phx.gbl...
>|||Lines: 102
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896
NNTP-Posting-Host: line40.comsat.net.ar 200.47.78.40
Xref: leafnode.mcse.ms microsoft.public.sqlserver.connect:1884
come on, hit me...
anyway, thanks both
for reply with respect
you are very kind
|<aiser Soze
"Sue Hoegemeier" <Sue_H@.nomail.please> escribi en el mensaje
news:jfmg03toi97nkhslost93k5ir0s5ina8jc@.
4ax.com...
> I just googled it and found a free one on the first hit - a
> download from sourceforge:
> About pymssql
> This module provides access to Microsoft SQL Servers from
> Python scripts. It's the most efficient method of accessing
> MS SQL Server's data from Python scripts.
> http://pymssql.sourceforge.net/
> And in the first few hits there was this:
> Microsoft SQL Server Express / Python HOWTO
>
http://www.time-travellers.org/shan...thon-HOWTO.html
> -Sue
> On Mon, 26 Mar 2007 15:50:43 -0300, "keyser soze"
> <bajopalabra@.hotmail.com> wrote:
>
party[vbcol=seagreen]
as[vbcol=seagreen]
mensaje[vbcol=seagreen]
language. I[vbcol=seagreen]
>