Error Locating Server/Instance Specified

I am having a problem connecting to my sql server express instance from a remote computer. I continue to get the above mentioned error. If I connect for the localhost everything works fine however when I try to connect from a different computer on the LAN it gives me this error. I have turned on remote access and still no luck. Any ideas? Any help would be appreciated.

Odds are you haven't created exceptions in the firewall on the remote computer to allow SQL to communicate through it. Check out the complete instructions for enableing remote connections to SQL Express in the KB, http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277.

FYI - This info is in the FAQ at the top of the forum is you need it again.

Mike

|||

Hi,

Ensure their is no network congesion between PCs you are connecting,

are they on same network segment !?

do you get ping acknoledgement when you ping your sql express from remote pc?

i would suggest you to refer http://support.microsoft.com/kb/905618/en-us also.

Hemantgiri S. Goswami

Error Locating Server/Instance Specified

I am having a problem connecting to my sql server express instance from a remote computer. I continue to get the above mentioned error. If I connect for the localhost everything works fine however when I try to connect from a different computer on the LAN it gives me this error. I have turned on remote access and still no luck. Any ideas? Any help would be appreciated.

Odds are you haven't created exceptions in the firewall on the remote computer to allow SQL to communicate through it. Check out the complete instructions for enableing remote connections to SQL Express in the KB, http://support.microsoft.com/default.aspx?scid=kb;EN-US;914277.

FYI - This info is in the FAQ at the top of the forum is you need it again.

Mike

|||

Hi,

Ensure their is no network congesion between PCs you are connecting,

are they on same network segment !?

do you get ping acknoledgement when you ping your sql express from remote pc?

i would suggest you to refer http://support.microsoft.com/kb/905618/en-us also.

Hemantgiri S. Goswami

error ITransactionJoin::JoinTransaction

We have job that runs on sql server 2000 every mintute, the job logic is to retrieve data from remote sql 2000 server using link server config. 98% of the time the job run sucessfully, but once in while the job fails with the following error:
'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)
[SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider
'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x80004005: ].
[SQLSTATE 01000] (Error 7300). The step failed.
Does, anyone know why is this happening?
Thank You,
Jason
Jason,
What version of Windows are you using? If Windows 2000, make sure you
are on SP4. This might solve it. Also, check that there is not a
firewall between the servers, if there is, ensure that RPC traffic is
allowed through.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Jason wrote:
> We have job that runs on sql server 2000 every mintute, the job logic is to retrieve data from remote sql 2000 server using link server config. 98% of the time the job run sucessfully, but once in while the job fails with the following error:
> 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)
> [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider
> 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x80004005: ].
> [SQLSTATE 01000] (Error 7300). The step failed.
> Does, anyone know why is this happening?
> Thank You,
> Jason
|||All the server that communiate with each other using link config do have sp4 for windows 2000 and there is no firewall between the servers.
|||Jason,
This looks like a case for Microsoft Support.
http://support.microsoft.com/default...d=fh;EN-US;sql
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
jason wrote:
> All the server that communiate with each other using link config do have sp4 for windows 2000 and there is no firewall between the servers.

error ITransactionJoin::JoinTransaction

We have job that runs on sql server 2000 every mintute, the job logic is to
retrieve data from remote sql 2000 server using link server config. 98% of t
he time the job run sucessfully, but once in while the job fails with the fo
llowing error:
'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)
[SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider
'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x80004005: ].
[SQLSTATE 01000] (Error 7300). The step failed.
Does, anyone know why is this happening?
Thank You,
JasonJason,
What version of Windows are you using? If Windows 2000, make sure you
are on SP4. This might solve it. Also, check that there is not a
firewall between the servers, if there is, ensure that RPC traffic is
allowed through.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Jason wrote:
> We have job that runs on sql server 2000 every mintute, the job logic is t
o retrieve data from remote sql 2000 server using link server config. 98% of
the time the job run sucessfully, but once in while the job fails with the
following error:
> 'SQLOLEDB' reported an error. [SQLSTATE 42000] (Error 7399)
> [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provide
r
> 'SQLOLEDB' ITransactionJoin::JoinTransaction returned 0x80004005: ].
> [SQLSTATE 01000] (Error 7300). The step failed.
> Does, anyone know why is this happening?
> Thank You,
> Jason|||All the server that communiate with each other using link config do have sp4
for Windows 2000 and there is no firewall between the servers.|||Jason,
This looks like a case for Microsoft Support.
http://support.microsoft.com/defaul...id=fh;EN-US;sql
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
jason wrote:
> All the server that communiate with each other using link config do have sp4 for w
indows 2000 and there is no firewall between the servers.

Error in SQL 2005 Maintenance Plan

I'm trying to setup a nightly backup to a remote computer using an SQL
Server 2005 Maintenance Plan. It keeps giving an error. I've narrowed
the cause down to an execute command...
EXECUTE master.dbo.xp_create_subdir
N'\\\\10.2.32.15\\Backup_SQL2005\\\\IOC'
which is giving the error below...
Msg 22048, Level 16, State 1, Line 0
xp_create_subdir() returned error 123, 'The filename, directory name,
or volume label syntax is incorrect.'
I am signed on as administrator on both computers. I'm able to map a
drive though the Windows Explorer and create a subdirectory on the
remote machine.
I have also tried...
EXECUTE master.dbo.xp_create_subdir N'\\10.2.32.15\Backup_SQL2005\IOC'
EXECUTE master.dbo.xp_create_subdir N'\\GOMB-BACKUP\Backup_SQL2005\IOC'
EXECUTE master.dbo.xp_create_subdir N'G:\IOC' (after mapping a drive)
This works...
EXECUTE master.dbo.xp_create_subdir N'C:\IOC'
...but of course it's on the local computer.
Any ideas why this doesn't work?
Thanks,
CThe stuff you do in Explorer uses the Windows account *you* have logged in w
ith. The stuff that SQL
Server does uses the Service account for the SQL Server service. Verify that
the service account has
proper permissions.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"The Cornjerker" <addoty@.gmail.com> wrote in message
news:1140218704.513963.300930@.g44g2000cwa.googlegroups.com...
> I'm trying to setup a nightly backup to a remote computer using an SQL
> Server 2005 Maintenance Plan. It keeps giving an error. I've narrowed
> the cause down to an execute command...
> EXECUTE master.dbo.xp_create_subdir
> N'\\\\10.2.32.15\\Backup_SQL2005\\\\IOC'
> which is giving the error below...
> Msg 22048, Level 16, State 1, Line 0
> xp_create_subdir() returned error 123, 'The filename, directory name,
> or volume label syntax is incorrect.'
> I am signed on as administrator on both computers. I'm able to map a
> drive though the Windows Explorer and create a subdirectory on the
> remote machine.
> I have also tried...
> EXECUTE master.dbo.xp_create_subdir N'\\10.2.32.15\Backup_SQL2005\IOC'
> EXECUTE master.dbo.xp_create_subdir N'\\GOMB-BACKUP\Backup_SQL2005\IOC'
> EXECUTE master.dbo.xp_create_subdir N'G:\IOC' (after mapping a drive)
> This works...
> EXECUTE master.dbo.xp_create_subdir N'C:\IOC'
> ...but of course it's on the local computer.
> Any ideas why this doesn't work?
> Thanks,
> C
>|||Tibor, thanks for the replay.
How do I give the Service account access to create remote
subdirectories?
C|||The Cornjerker (addoty@.gmail.com) writes:
> Tibor, thanks for the replay.
> How do I give the Service account access to create remote
> subdirectories?
As you would to for any other Windows user. (Which if you don't know is
a question for a Windows newsgroup. I hardly know it myself.)
Note howver, that you cannot do this if SQL Server is running under
Local System. In this case you need to change which account under which
SQL Server is running. To do this, right-click My Computer, select Manager,
find Services, and there find the SQL Server service. Double-click, and
log-on information is on the Log On tab.
If you are using SQL 2005, you should use the SQL Computer Manager instead.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland,
Thanks for the replay. Are there any divantages to running the
MSSQLSERVER service under the Administrator account?
C

Error in report services

Hi all,

I am getting the following error when iam trying to deploy my reports on a remote report server (remote machine).can anyone help me in this regard?its very urgent.

The permissions granted to user 'domainname\userid' are insufficient for performing this operation.

Thanks in advance.

Hi,

the user has to be at miminum in the publisher role. Otherwise he won′t be able to make a call to the webservice.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Error In Log

Morning All,
Rececntly I have been getting quite a few errors on the resotre of my
databases, what happens is the files are downloaded from a remote server,
unziped and then I run some script to restore them.....this has been working
fine for quite some time with no problems whatsoever, until recently where
things have been crashing and my databases have been getting set to
Single-User mode which I do not want. I thought the failing of the restores
might have been a conflict in times of when things happen so I have made some
changes where this can not possibly be the issue, and I have now removed the
ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script from my
restore process as a temp measure. After all this I am now getting a strange
error in the Log Files which I am not really sure what it means so I am
hoping someone can help, it says -:
BackupDiskFile::OpenMedia: Backup device
'C:\Download\Found' failed to open. Operating
syster error = 2(error not found).
Thanks for any help offered and I am currently using SQL Server 2000
Thanks PD
Phil
When you say "some script to restore them.." , did you mean you was be able
to restore database? If so , do you have last backup of the database?
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:9E7F83F5-DC98-497D-ACE0-C781B7304B89@.microsoft.com...
> Morning All,
> Rececntly I have been getting quite a few errors on the resotre of my
> databases, what happens is the files are downloaded from a remote server,
> unziped and then I run some script to restore them.....this has been
> working
> fine for quite some time with no problems whatsoever, until recently where
> things have been crashing and my databases have been getting set to
> Single-User mode which I do not want. I thought the failing of the
> restores
> might have been a conflict in times of when things happen so I have made
> some
> changes where this can not possibly be the issue, and I have now removed
> the
> ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script from
> my
> restore process as a temp measure. After all this I am now getting a
> strange
> error in the Log Files which I am not really sure what it means so I am
> hoping someone can help, it says -:
> BackupDiskFile::OpenMedia: Backup device
> 'C:\Download\Found' failed to open. Operating
> syster error = 2(error not found).
> Thanks for any help offered and I am currently using SQL Server 2000
> Thanks PD
|||Hi,
Thanks for the quick reply, yes I do have the last backup of the database,
the databases are downloaded to a folder on the SQL Server and then Restored
from there! I can get them to restore but there seems to be problems with
the reliability at the moment! Thats why I thought the error message that I
posted here might have something to do with it
Thanks for you help, Phil
"Uri Dimant" wrote:

> Phil
> When you say "some script to restore them.." , did you mean you was be able
> to restore database? If so , do you have last backup of the database?
>
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:9E7F83F5-DC98-497D-ACE0-C781B7304B89@.microsoft.com...
>
>
|||Phil
Don't you perform BACKUP LOG ...?
Have you ran RESTORE HEADERONLY ... before to perfom RESTORE command?
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:48B6E075-AE9E-4AB8-ADB5-9C958C0588A2@.microsoft.com...[vbcol=seagreen]
> Hi,
> Thanks for the quick reply, yes I do have the last backup of the database,
> the databases are downloaded to a folder on the SQL Server and then
> Restored
> from there! I can get them to restore but there seems to be problems with
> the reliability at the moment! Thats why I thought the error message that
> I
> posted here might have something to do with it
>
> Thanks for you help, Phil
> "Uri Dimant" wrote:
|||Windows Error codes are listed here:
http://www.support.tabs3.com/main/R10307.htm
Error code 2 means file not found.
Paul
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23xFWWtF6GHA.5068@.TK2MSFTNGP06.phx.gbl...
> Phil
> Don't you perform BACKUP LOG ...?
> Have you ran RESTORE HEADERONLY ... before to perfom RESTORE command?
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:48B6E075-AE9E-4AB8-ADB5-9C958C0588A2@.microsoft.com...
>
|||Hi Uri,
No I dont perform a BACKUP LOG, the database that I download comes from a
completely different company from the one that I work for and during the day
they perform (Complete Backups) and then we download them as zip files where
I then unpack them and restore over the top of the previous one. The script
that I have loads all the backups names into a table for a specific database
that I want to restore and lists them by date and picks the most recent
backup to restore!
Thanks Phil
"Uri Dimant" wrote:

> Phil
> Don't you perform BACKUP LOG ...?
> Have you ran RESTORE HEADERONLY ... before to perfom RESTORE command?
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:48B6E075-AE9E-4AB8-ADB5-9C958C0588A2@.microsoft.com...
>
>

Error In Log

Morning All,
Rececntly I have been getting quite a few errors on the resotre of my
databases, what happens is the files are downloaded from a remote server,
unziped and then I run some script to restore them.....this has been workin
g
fine for quite some time with no problems whatsoever, until recently where
things have been crashing and my databases have been getting set to
Single-User mode which I do not want. I thought the failing of the restores
might have been a conflict in times of when things happen so I have made som
e
changes where this can not possibly be the issue, and I have now removed the
ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script from my
restore process as a temp measure. After all this I am now getting a strang
e
error in the Log Files which I am not really sure what it means so I am
hoping someone can help, it says -:
BackupDiskFile::OpenMedia: Backup device
'C:\Download\Found' failed to open. Operating
syster error = 2(error not found).
Thanks for any help offered and I am currently using SQL Server 2000
Thanks PDPhil
When you say "some script to restore them.." , did you mean you was be able
to restore database? If so , do you have last backup of the database?
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:9E7F83F5-DC98-497D-ACE0-C781B7304B89@.microsoft.com...
> Morning All,
> Rececntly I have been getting quite a few errors on the resotre of my
> databases, what happens is the files are downloaded from a remote server,
> unziped and then I run some script to restore them.....this has been
> working
> fine for quite some time with no problems whatsoever, until recently where
> things have been crashing and my databases have been getting set to
> Single-User mode which I do not want. I thought the failing of the
> restores
> might have been a conflict in times of when things happen so I have made
> some
> changes where this can not possibly be the issue, and I have now removed
> the
> ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script from
> my
> restore process as a temp measure. After all this I am now getting a
> strange
> error in the Log Files which I am not really sure what it means so I am
> hoping someone can help, it says -:
> BackupDiskFile::OpenMedia: Backup device
> 'C:\Download\Found' failed to open. Operating
> syster error = 2(error not found).
> Thanks for any help offered and I am currently using SQL Server 2000
> Thanks PD|||Hi,
Thanks for the quick reply, yes I do have the last backup of the database,
the databases are downloaded to a folder on the SQL Server and then Restored
from there! I can get them to restore but there seems to be problems with
the reliability at the moment! Thats why I thought the error message that I
posted here might have something to do with it
Thanks for you help, Phil
"Uri Dimant" wrote:

> Phil
> When you say "some script to restore them.." , did you mean you was be abl
e
> to restore database? If so , do you have last backup of the database?
>
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:9E7F83F5-DC98-497D-ACE0-C781B7304B89@.microsoft.com...
>
>|||Phil
Don't you perform BACKUP LOG ...?
Have you ran RESTORE HEADERONLY ... before to perfom RESTORE command?
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:48B6E075-AE9E-4AB8-ADB5-9C958C0588A2@.microsoft.com...[vbcol=seagreen]
> Hi,
> Thanks for the quick reply, yes I do have the last backup of the database,
> the databases are downloaded to a folder on the SQL Server and then
> Restored
> from there! I can get them to restore but there seems to be problems with
> the reliability at the moment! Thats why I thought the error message that
> I
> posted here might have something to do with it
>
> Thanks for you help, Phil
> "Uri Dimant" wrote:
>|||Windows Error codes are listed here:
http://www.support.tabs3.com/main/R10307.htm
Error code 2 means file not found.
Paul
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23xFWWtF6GHA.5068@.TK2MSFTNGP06.phx.gbl...
> Phil
> Don't you perform BACKUP LOG ...?
> Have you ran RESTORE HEADERONLY ... before to perfom RESTORE command?
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:48B6E075-AE9E-4AB8-ADB5-9C958C0588A2@.microsoft.com...
>|||Hi Uri,
No I dont perform a BACKUP LOG, the database that I download comes from a
completely different company from the one that I work for and during the day
they perform (Complete Backups) and then we download them as zip files where
I then unpack them and restore over the top of the previous one. The script
that I have loads all the backups names into a table for a specific database
that I want to restore and lists them by date and picks the most recent
backup to restore!
Thanks Phil
"Uri Dimant" wrote:

> Phil
> Don't you perform BACKUP LOG ...?
> Have you ran RESTORE HEADERONLY ... before to perfom RESTORE command?
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:48B6E075-AE9E-4AB8-ADB5-9C958C0588A2@.microsoft.com...
>
>

Error In Log

Morning All,
Rececntly I have been getting quite a few errors on the resotre of my
databases, what happens is the files are downloaded from a remote server,
unziped and then I run some script to restore them.....this has been working
fine for quite some time with no problems whatsoever, until recently where
things have been crashing and my databases have been getting set to
Single-User mode which I do not want. I thought the failing of the restores
might have been a conflict in times of when things happen so I have made some
changes where this can not possibly be the issue, and I have now removed the
ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script from my
restore process as a temp measure. After all this I am now getting a strange
error in the Log Files which I am not really sure what it means so I am
hoping someone can help, it says -:
BackupDiskFile::OpenMedia: Backup device
'C:\Download\Found' failed to open. Operating
syster error = 2(error not found).
Thanks for any help offered and I am currently using SQL Server 2000
Thanks PDPhil
When you say "some script to restore them.." , did you mean you was be able
to restore database? If so , do you have last backup of the database?
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:9E7F83F5-DC98-497D-ACE0-C781B7304B89@.microsoft.com...
> Morning All,
> Rececntly I have been getting quite a few errors on the resotre of my
> databases, what happens is the files are downloaded from a remote server,
> unziped and then I run some script to restore them.....this has been
> working
> fine for quite some time with no problems whatsoever, until recently where
> things have been crashing and my databases have been getting set to
> Single-User mode which I do not want. I thought the failing of the
> restores
> might have been a conflict in times of when things happen so I have made
> some
> changes where this can not possibly be the issue, and I have now removed
> the
> ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script from
> my
> restore process as a temp measure. After all this I am now getting a
> strange
> error in the Log Files which I am not really sure what it means so I am
> hoping someone can help, it says -:
> BackupDiskFile::OpenMedia: Backup device
> 'C:\Download\Found' failed to open. Operating
> syster error = 2(error not found).
> Thanks for any help offered and I am currently using SQL Server 2000
> Thanks PD|||Hi,
Thanks for the quick reply, yes I do have the last backup of the database,
the databases are downloaded to a folder on the SQL Server and then Restored
from there! I can get them to restore but there seems to be problems with
the reliability at the moment! Thats why I thought the error message that I
posted here might have something to do with it
Thanks for you help, Phil
"Uri Dimant" wrote:
> Phil
> When you say "some script to restore them.." , did you mean you was be able
> to restore database? If so , do you have last backup of the database?
>
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:9E7F83F5-DC98-497D-ACE0-C781B7304B89@.microsoft.com...
> > Morning All,
> >
> > Rececntly I have been getting quite a few errors on the resotre of my
> > databases, what happens is the files are downloaded from a remote server,
> > unziped and then I run some script to restore them.....this has been
> > working
> > fine for quite some time with no problems whatsoever, until recently where
> > things have been crashing and my databases have been getting set to
> > Single-User mode which I do not want. I thought the failing of the
> > restores
> > might have been a conflict in times of when things happen so I have made
> > some
> > changes where this can not possibly be the issue, and I have now removed
> > the
> > ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script from
> > my
> > restore process as a temp measure. After all this I am now getting a
> > strange
> > error in the Log Files which I am not really sure what it means so I am
> > hoping someone can help, it says -:
> >
> > BackupDiskFile::OpenMedia: Backup device
> > 'C:\Download\Found' failed to open. Operating
> > syster error = 2(error not found).
> >
> > Thanks for any help offered and I am currently using SQL Server 2000
> >
> > Thanks PD
>
>|||Phil
Don't you perform BACKUP LOG ...?
Have you ran RESTORE HEADERONLY ... before to perfom RESTORE command?
"Phil" <Phil@.discussions.microsoft.com> wrote in message
news:48B6E075-AE9E-4AB8-ADB5-9C958C0588A2@.microsoft.com...
> Hi,
> Thanks for the quick reply, yes I do have the last backup of the database,
> the databases are downloaded to a folder on the SQL Server and then
> Restored
> from there! I can get them to restore but there seems to be problems with
> the reliability at the moment! Thats why I thought the error message that
> I
> posted here might have something to do with it
>
> Thanks for you help, Phil
> "Uri Dimant" wrote:
>> Phil
>> When you say "some script to restore them.." , did you mean you was be
>> able
>> to restore database? If so , do you have last backup of the database?
>>
>>
>> "Phil" <Phil@.discussions.microsoft.com> wrote in message
>> news:9E7F83F5-DC98-497D-ACE0-C781B7304B89@.microsoft.com...
>> > Morning All,
>> >
>> > Rececntly I have been getting quite a few errors on the resotre of my
>> > databases, what happens is the files are downloaded from a remote
>> > server,
>> > unziped and then I run some script to restore them.....this has been
>> > working
>> > fine for quite some time with no problems whatsoever, until recently
>> > where
>> > things have been crashing and my databases have been getting set to
>> > Single-User mode which I do not want. I thought the failing of the
>> > restores
>> > might have been a conflict in times of when things happen so I have
>> > made
>> > some
>> > changes where this can not possibly be the issue, and I have now
>> > removed
>> > the
>> > ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script
>> > from
>> > my
>> > restore process as a temp measure. After all this I am now getting a
>> > strange
>> > error in the Log Files which I am not really sure what it means so I am
>> > hoping someone can help, it says -:
>> >
>> > BackupDiskFile::OpenMedia: Backup device
>> > 'C:\Download\Found' failed to open. Operating
>> > syster error = 2(error not found).
>> >
>> > Thanks for any help offered and I am currently using SQL Server 2000
>> >
>> > Thanks PD
>>|||Windows Error codes are listed here:
http://www.support.tabs3.com/main/R10307.htm
Error code 2 means file not found.
Paul
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%23xFWWtF6GHA.5068@.TK2MSFTNGP06.phx.gbl...
> Phil
> Don't you perform BACKUP LOG ...?
> Have you ran RESTORE HEADERONLY ... before to perfom RESTORE command?
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:48B6E075-AE9E-4AB8-ADB5-9C958C0588A2@.microsoft.com...
>> Hi,
>> Thanks for the quick reply, yes I do have the last backup of the
>> database,
>> the databases are downloaded to a folder on the SQL Server and then
>> Restored
>> from there! I can get them to restore but there seems to be problems
>> with
>> the reliability at the moment! Thats why I thought the error message
>> that I
>> posted here might have something to do with it
>>
>> Thanks for you help, Phil
>> "Uri Dimant" wrote:
>> Phil
>> When you say "some script to restore them.." , did you mean you was be
>> able
>> to restore database? If so , do you have last backup of the database?
>>
>>
>> "Phil" <Phil@.discussions.microsoft.com> wrote in message
>> news:9E7F83F5-DC98-497D-ACE0-C781B7304B89@.microsoft.com...
>> > Morning All,
>> >
>> > Rececntly I have been getting quite a few errors on the resotre of my
>> > databases, what happens is the files are downloaded from a remote
>> > server,
>> > unziped and then I run some script to restore them.....this has been
>> > working
>> > fine for quite some time with no problems whatsoever, until recently
>> > where
>> > things have been crashing and my databases have been getting set to
>> > Single-User mode which I do not want. I thought the failing of the
>> > restores
>> > might have been a conflict in times of when things happen so I have
>> > made
>> > some
>> > changes where this can not possibly be the issue, and I have now
>> > removed
>> > the
>> > ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script
>> > from
>> > my
>> > restore process as a temp measure. After all this I am now getting a
>> > strange
>> > error in the Log Files which I am not really sure what it means so I
>> > am
>> > hoping someone can help, it says -:
>> >
>> > BackupDiskFile::OpenMedia: Backup device
>> > 'C:\Download\Found' failed to open. Operating
>> > syster error = 2(error not found).
>> >
>> > Thanks for any help offered and I am currently using SQL Server 2000
>> >
>> > Thanks PD
>>
>|||Hi Uri,
No I dont perform a BACKUP LOG, the database that I download comes from a
completely different company from the one that I work for and during the day
they perform (Complete Backups) and then we download them as zip files where
I then unpack them and restore over the top of the previous one. The script
that I have loads all the backups names into a table for a specific database
that I want to restore and lists them by date and picks the most recent
backup to restore!
Thanks Phil
"Uri Dimant" wrote:
> Phil
> Don't you perform BACKUP LOG ...?
> Have you ran RESTORE HEADERONLY ... before to perfom RESTORE command?
>
> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> news:48B6E075-AE9E-4AB8-ADB5-9C958C0588A2@.microsoft.com...
> > Hi,
> >
> > Thanks for the quick reply, yes I do have the last backup of the database,
> > the databases are downloaded to a folder on the SQL Server and then
> > Restored
> > from there! I can get them to restore but there seems to be problems with
> > the reliability at the moment! Thats why I thought the error message that
> > I
> > posted here might have something to do with it
> >
> >
> > Thanks for you help, Phil
> >
> > "Uri Dimant" wrote:
> >
> >> Phil
> >> When you say "some script to restore them.." , did you mean you was be
> >> able
> >> to restore database? If so , do you have last backup of the database?
> >>
> >>
> >>
> >>
> >> "Phil" <Phil@.discussions.microsoft.com> wrote in message
> >> news:9E7F83F5-DC98-497D-ACE0-C781B7304B89@.microsoft.com...
> >> > Morning All,
> >> >
> >> > Rececntly I have been getting quite a few errors on the resotre of my
> >> > databases, what happens is the files are downloaded from a remote
> >> > server,
> >> > unziped and then I run some script to restore them.....this has been
> >> > working
> >> > fine for quite some time with no problems whatsoever, until recently
> >> > where
> >> > things have been crashing and my databases have been getting set to
> >> > Single-User mode which I do not want. I thought the failing of the
> >> > restores
> >> > might have been a conflict in times of when things happen so I have
> >> > made
> >> > some
> >> > changes where this can not possibly be the issue, and I have now
> >> > removed
> >> > the
> >> > ALTER DATABASE .....SET SINGLE-USER WITH IMMEDIATE ROLLBACK script
> >> > from
> >> > my
> >> > restore process as a temp measure. After all this I am now getting a
> >> > strange
> >> > error in the Log Files which I am not really sure what it means so I am
> >> > hoping someone can help, it says -:
> >> >
> >> > BackupDiskFile::OpenMedia: Backup device
> >> > 'C:\Download\Found' failed to open. Operating
> >> > syster error = 2(error not found).
> >> >
> >> > Thanks for any help offered and I am currently using SQL Server 2000
> >> >
> >> > Thanks PD
> >>
> >>
> >>
>
>

Error Handling-- no connection

I have a package that connects to remote AS400. I am wondering what is the best way to handle situation if my package could not connect to source.

-kushpaw

kushpaw wrote:

I have a package that connects to remote AS400. I am wondering what is the best way to handle situation if my package could not connect to source.

-kushpaw

There is no best way but here's a suggestion:

Verify a data source before using it
(http://blogs.conchango.com/jamiethomson/archive/2005/10/10/2253.aspx)

-Jamie

|||thanks, that ' a good start.