Hello everyone,
I am running in a cluster setup (this is working ok).
I cannot get the mssqlserver service to start.
Here is the error log...
2007-12-19 10:41:38.50 server Microsoft SQL Server 2000 - 8.00.2040
(Intel X86)
May 13 2005 18:33:17
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2007-12-19 10:41:38.50 server Copyright (C) 1988-2002 Microsoft
Corporation.
2007-12-19 10:41:38.50 server All rights reserved.
2007-12-19 10:41:38.50 server Server Process ID is 3068.
2007-12-19 10:41:38.50 server Logging SQL Server messages in file
'Z:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2007-12-19 10:41:38.50 server SQL Server is starting at priority class
'normal'(4 CPUs detected).
2007-12-19 10:41:38.51 server Cannot use Address Windowing Extensions
because lock memory privilege was not granted.
2007-12-19 10:41:38.56 server Working Set size set to 1520448 kilobytes.
2007-12-19 10:41:38.57 server SQL Server configured for thread mode
processing.
2007-12-19 10:41:38.59 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2007-12-19 10:41:38.65 server Attempting to initialize Distributed
Transaction Coordinator.
2007-12-19 10:41:38.65 server Failed to obtain
TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE
2007-12-19 10:41:38.65 spid3 Starting up database 'master'.
2007-12-19 10:41:38.68 server Using 'SSNETLIB.DLL' version '8.0.2039'.
2007-12-19 10:41:38.68 spid5 Starting up database 'model'.
2007-12-19 10:41:38.68 spid3 Server name is 'SQLVIRTUALA'.
2007-12-19 10:41:38.68 spid8 Starting up database 'msdb'.
2007-12-19 10:41:38.68 spid9 Starting up database 'QFWinData_ProdFinal'.
2007-12-19 10:41:38.68 spid10 Starting up database 'QFWinData_Template'.
2007-12-19 10:41:38.68 spid11 Starting up database 'QFWinData_ProdTest'.
2007-12-19 10:41:38.68 spid12 Starting up database 'QFWinData_QQ999992'.
2007-12-19 10:41:38.68 spid13 Starting up database 'Common'.
2007-12-19 10:41:38.68 spid14 Starting up database 'DBAWork'.
2007-12-19 10:41:38.68 server Error: 17826, Severity: 18, State: 1
2007-12-19 10:41:38.68 server Could not set up Net-Library 'SSNETLIB'..
2007-12-19 10:41:38.68 server Unable to load any netlibs.
2007-12-19 10:41:38.68 server SQL Server could not spawn FRunCM thread.
Since i cannot get any service pack to install, i am stuck at SP1 level.
I thought there was an issue with the SSL, but i have the certificates
loaded on both nodes of the cluster.
I thought it was a permissions issue, so i set both the MSSQLServer and
SQLAgent to a new domain admininstration level user. still won't start.
Please advise
take care
tony
See if this applies:
http://support.microsoft.com/kb/815431
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"pithhelmet" <pithhelmet@.discussions.microsoft.com> wrote in message
news:1EC91A6E-E933-4891-96E3-B001DDC312EF@.microsoft.com...
> Hello everyone,
> I am running in a cluster setup (this is working ok).
> I cannot get the mssqlserver service to start.
> Here is the error log...
>
> 2007-12-19 10:41:38.50 server Microsoft SQL Server 2000 - 8.00.2040
> (Intel X86)
> May 13 2005 18:33:17
> Copyright (c) 1988-2003 Microsoft Corporation
> Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
> 2007-12-19 10:41:38.50 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2007-12-19 10:41:38.50 server All rights reserved.
> 2007-12-19 10:41:38.50 server Server Process ID is 3068.
> 2007-12-19 10:41:38.50 server Logging SQL Server messages in file
> 'Z:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2007-12-19 10:41:38.50 server SQL Server is starting at priority class
> 'normal'(4 CPUs detected).
> 2007-12-19 10:41:38.51 server Cannot use Address Windowing Extensions
> because lock memory privilege was not granted.
> 2007-12-19 10:41:38.56 server Working Set size set to 1520448
> kilobytes.
> 2007-12-19 10:41:38.57 server SQL Server configured for thread mode
> processing.
> 2007-12-19 10:41:38.59 server Using dynamic lock allocation. [2500]
> Lock
> Blocks, [5000] Lock Owner Blocks.
> 2007-12-19 10:41:38.65 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2007-12-19 10:41:38.65 server Failed to obtain
> TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE
> 2007-12-19 10:41:38.65 spid3 Starting up database 'master'.
> 2007-12-19 10:41:38.68 server Using 'SSNETLIB.DLL' version '8.0.2039'.
> 2007-12-19 10:41:38.68 spid5 Starting up database 'model'.
> 2007-12-19 10:41:38.68 spid3 Server name is 'SQLVIRTUALA'.
> 2007-12-19 10:41:38.68 spid8 Starting up database 'msdb'.
> 2007-12-19 10:41:38.68 spid9 Starting up database
> 'QFWinData_ProdFinal'.
> 2007-12-19 10:41:38.68 spid10 Starting up database
> 'QFWinData_Template'.
> 2007-12-19 10:41:38.68 spid11 Starting up database
> 'QFWinData_ProdTest'.
> 2007-12-19 10:41:38.68 spid12 Starting up database
> 'QFWinData_QQ999992'.
> 2007-12-19 10:41:38.68 spid13 Starting up database 'Common'.
> 2007-12-19 10:41:38.68 spid14 Starting up database 'DBAWork'.
> 2007-12-19 10:41:38.68 server Error: 17826, Severity: 18, State: 1
> 2007-12-19 10:41:38.68 server Could not set up Net-Library 'SSNETLIB'..
> 2007-12-19 10:41:38.68 server Unable to load any netlibs.
> 2007-12-19 10:41:38.68 server SQL Server could not spawn FRunCM thread.
>
> Since i cannot get any service pack to install, i am stuck at SP1 level.
> I thought there was an issue with the SSL, but i have the certificates
> loaded on both nodes of the cluster.
> I thought it was a permissions issue, so i set both the MSSQLServer and
> SQLAgent to a new domain admininstration level user. still won't start.
> Please advise
> take care
> tony
>
|||Hi Geoff,
No, this did not help in any way.
The SQL Server is already installed.
I simply cannot get it to start.
thanks for the reply.
take care
tony
"Geoff N. Hiten" wrote:
> See if this applies:
> http://support.microsoft.com/kb/815431
> --
> Geoff N. Hiten
> Senior SQL Infrastructure Consultant
> Microsoft SQL Server MVP
>
> "pithhelmet" <pithhelmet@.discussions.microsoft.com> wrote in message
> news:1EC91A6E-E933-4891-96E3-B001DDC312EF@.microsoft.com...
>
Showing posts with label mssqlserver. Show all posts
Showing posts with label mssqlserver. Show all posts
Wednesday, March 7, 2012
Saturday, February 25, 2012
cannot start report server on local computer
HI,
I tried to deploy reports on locahost. Yet, I still need to start the mssqlserver service on local computer. I tried all the possibilities shown from the help but still i can't have it started. How will i start mssqlserver service on local computer alone?
thanks
soWillingToLearn,
What are your settings for the msSQLserver service LogOn? Can you check your application log file under Event Viewer to see what error message is being generated.
Ham
Friday, February 10, 2012
Cannot restore database from a remote server
I am unable to restore a new database from a backup located in a different
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.
Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Cool... I've been looking for a more efficient way to managing updating our
development server...
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> administrator,
> trying
> can
>
|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.
Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Cool... I've been looking for a more efficient way to managing updating our
development server...
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> administrator,
> trying
> can
>
|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
Cannot restore database from a remote server
I am unable to restore a new database from a backup located in a different
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Cool... I've been looking for a more efficient way to managing updating our
development server...
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> administrator,
> trying
> can
>|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Cool... I've been looking for a more efficient way to managing updating our
development server...
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> administrator,
> trying
> can
>|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
Cannot restore database from a remote server
I am unable to restore a new database from a backup located in a different
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Cool... I've been looking for a more efficient way to managing updating our
development server...
--
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
>> I am unable to restore a new database from a backup located in a
>> different
>> server. The MSSQLSERVER service starts with the same network
> administrator,
>> who has sysadmin rights, for both servers. The problem is that when
> trying
>> to restore from the Enterprise Manager I cannot see the mapped drive nor
> can
>> I setup a backup device to the computer containing the backup. Are there
>> any pointers that any of you can give me on how to resolve this problem?
>> Thanks in advance for your help.
>>
>|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>|||Cool... I've been looking for a more efficient way to managing updating our
development server...
--
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
>> I am unable to restore a new database from a backup located in a
>> different
>> server. The MSSQLSERVER service starts with the same network
> administrator,
>> who has sysadmin rights, for both servers. The problem is that when
> trying
>> to restore from the Enterprise Manager I cannot see the mapped drive nor
> can
>> I setup a backup device to the computer containing the backup. Are there
>> any pointers that any of you can give me on how to resolve this problem?
>> Thanks in advance for your help.
>>
>|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
Cannot restore database from a remote server
I am unable to restore a new database from a backup located in a different
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.
Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Cool... I've been looking for a more efficient way to managing updating our
development server...
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> administrator,
> trying
> can
>
|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
server. The MSSQLSERVER service starts with the same network administrator,
who has sysadmin rights, for both servers. The problem is that when trying
to restore from the Enterprise Manager I cannot see the mapped drive nor can
I setup a backup device to the computer containing the backup. Are there
any pointers that any of you can give me on how to resolve this problem?
Thanks in advance for your help.
Hi
SQL Enterprise Manager does not look at mapped drives.
You need to use T-SQL code (RESTORE DATABASE) and supply the file name using
UNC naming (\\machinename\sharename\backup.bak)
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Look at the checklist in the following article for backup access to a UNC
chare. It is the same for restore file access.
http://support.microsoft.com/?kbid=555128
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
|||Cool... I've been looking for a more efficient way to managing updating our
development server...
Regards,
Hank Arnold
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:OgJfyv01EHA.3816@.TK2MSFTNGP09.phx.gbl...
> Look at the checklist in the following article for backup access to a UNC
> chare. It is the same for restore file access.
> http://support.microsoft.com/?kbid=555128
>
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
> news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> administrator,
> trying
> can
>
|||Thanks to all of you that took the time to answer my posting. Your help is
truly appreciated.
"Pete Ocasio" <pete.ocasio@.execupay.com> wrote in message
news:OkbKGRz1EHA.1408@.TK2MSFTNGP10.phx.gbl...
> I am unable to restore a new database from a backup located in a different
> server. The MSSQLSERVER service starts with the same network
administrator,
> who has sysadmin rights, for both servers. The problem is that when
trying
> to restore from the Enterprise Manager I cannot see the mapped drive nor
can
> I setup a backup device to the computer containing the backup. Are there
> any pointers that any of you can give me on how to resolve this problem?
> Thanks in advance for your help.
>
Subscribe to:
Posts (Atom)