Can't attach 2005 DB on Vista - Erland? Anyone? Help me please!

Dear Group

I've installed MSSQL 2005 STD on Vista and now can't attach my
databases.
I've installed SQL SP2 and the SQL Vista Beta Update.
The error I'm getting is:

Unable to open the physical file <Path to MDF>. Operating system error
5: '''5(Error not found)'''. (Microsoft SQL Server, Error: 5120)

Thanks for your help. All your hints are very much appreciated.

Thanks,

Martin N Feuersteiner
Invent2b GroupOn 1 Mar, 14:19, theintrepid...@.hotmail.com wrote:

Quote:

Originally Posted by

Dear Group
>
I've installed MSSQL 2005 STD on Vista and now can't attach my
databases.
I've installed SQL SP2 and the SQL Vista Beta Update.
The error I'm getting is:
>
Unable to open the physical file <Path to MDF>. Operating system error
5: '''5(Error not found)'''. (Microsoft SQL Server, Error: 5120)

Found the Solution on Vista:

- Go to Control Panel and Switch to Classic View
- Click on User Accounts
- Click on Turn User Account Control on or off
- Uncheck use User Account Control (UAC) to help protect your
computer.
- OK
- Restart System

Try again to attach the DB. It should work now.

Hope this helps anyone else having this problem.

Martin
Invent2b Group|||(theintrepidfox@.hotmail.com) writes:

Quote:

Originally Posted by

Found the Solution on Vista:
>
- Go to Control Panel and Switch to Classic View
- Click on User Accounts
- Click on Turn User Account Control on or off
- Uncheck use User Account Control (UAC) to help protect your
computer.
- OK
- Restart System
>
Try again to attach the DB. It should work now.
>
Hope this helps anyone else having this problem.

Maybe a bit heavy-duty. The point with UAC in Vista as I understand it,
is that you should not run as Administrator all the time, only when you
need it. While running as Administrator is convenient, it makes it
easier for any infections your machines may catch to spread. I think
there is a context-menu option "Run As Administrator".

Personally, I have not had any encounter with Vista yet.

--
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|||On 1 Mar, 22:13, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

(theintrepid...@.hotmail.com) writes:

Quote:

Originally Posted by

Found the Solution on Vista:

>

Quote:

Originally Posted by

- Go to Control Panel and Switch to Classic View
- Click on User Accounts
- Click on Turn User Account Control on or off
- Uncheck use User Account Control (UAC) to help protect your
computer.
- OK
- Restart System

>

Quote:

Originally Posted by

Try again to attach the DB. It should work now.

>

Quote:

Originally Posted by

Hope this helps anyone else having this problem.

>
Maybe a bit heavy-duty. The point with UAC in Vista as I understand it,
is that you should not run as Administrator all the time, only when you
need it. While running as Administrator is convenient, it makes it
easier for any infections your machines may catch to spread. I think
there is a context-menu option "Run As Administrator".
>
Personally, I have not had any encounter with Vista yet.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>
Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Hi Erland

Correct. It's heavy duty and my first attempt was to right-click on
the Management Studio Icon and to choose the 'Run As Administrator'
option which didn't work.
UAC is indeed a good feature and helps to protect. But following this
process didn't solve the problem and there was no other choice than
having to turn off UAC.
I haven't tried turning UAC on since I attached the databases to see
what its effect is.

To put it short, UAC is good but not in a development environemnt.
Despite having turned it off VS 2005 still warns me that it may not
work correctly, needing Admin rights but it starts fine without any
errors so far. And anyway, what's the REAL risk of having it turned
off. A Vista machine with UAC off won't become less protected than a
XP machine used to be and any additional security software and common
user sense will help protect the same way. I reckon it's rather good
for my dad who clicks on and executes everything he's prompted with.
Bless him and his viruses.

If anyone has a better suggestion to this workaround which will work
with UAC on, please post it here.

All the best,

Martin
Invent2b Group|||(theintrepidfox@.hotmail.com) writes:

Quote:

Originally Posted by

Correct. It's heavy duty and my first attempt was to right-click on
the Management Studio Icon and to choose the 'Run As Administrator'
option which didn't work.
UAC is indeed a good feature and helps to protect. But following this
process didn't solve the problem and there was no other choice than
having to turn off UAC.
I haven't tried turning UAC on since I attached the databases to see
what its effect is.

Having today having had my first encounter with Vista, and I agree that it
is very irritating. (Then again, there seems to be a whole lot of
irritating fluff in Vista. I want to computer to run SQL Server on, I
don't want this "My Music" etc.)

No, I never came as far installing SQL Server. About every second time
I reboot, the machine powers off while Vista is starting. I will probably
change to a different motherboard.

--
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|||I agree UAC can be annoying on a development box but I've been running Vista
with UAC and haven't had to resort to turning it off. I need to run VS as
administrator. It's optional with SSMS depending on the features I use
(e.g. stop/start services requires admin).

--
Hope this helps.

Dan Guzman
SQL Server MVP

<theintrepidfox@.hotmail.comwrote in message
news:1173031039.763449.115250@.n33g2000cwc.googlegr oups.com...

Quote:

Originally Posted by

On 1 Mar, 22:13, Erland Sommarskog <esq...@.sommarskog.sewrote:

Quote:

Originally Posted by

> (theintrepid...@.hotmail.com) writes:

Quote:

Originally Posted by

Found the Solution on Vista:

>>

Quote:

Originally Posted by

- Go to Control Panel and Switch to Classic View
- Click on User Accounts
- Click on Turn User Account Control on or off
- Uncheck use User Account Control (UAC) to help protect your
computer.
- OK
- Restart System

>>

Quote:

Originally Posted by

Try again to attach the DB. It should work now.

>>

Quote:

Originally Posted by

Hope this helps anyone else having this problem.

>>
>Maybe a bit heavy-duty. The point with UAC in Vista as I understand it,
>is that you should not run as Administrator all the time, only when you
>need it. While running as Administrator is convenient, it makes it
>easier for any infections your machines may catch to spread. I think
>there is a context-menu option "Run As Administrator".
>>
>Personally, I have not had any encounter with Vista yet.
>>
>--
>Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>>
>Books Online for SQL Server 2005
>athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
>Books Online for SQL Server 2000
>athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

>
Hi Erland
>
Correct. It's heavy duty and my first attempt was to right-click on
the Management Studio Icon and to choose the 'Run As Administrator'
option which didn't work.
UAC is indeed a good feature and helps to protect. But following this
process didn't solve the problem and there was no other choice than
having to turn off UAC.
I haven't tried turning UAC on since I attached the databases to see
what its effect is.
>
To put it short, UAC is good but not in a development environemnt.
Despite having turned it off VS 2005 still warns me that it may not
work correctly, needing Admin rights but it starts fine without any
errors so far. And anyway, what's the REAL risk of having it turned
off. A Vista machine with UAC off won't become less protected than a
XP machine used to be and any additional security software and common
user sense will help protect the same way. I reckon it's rather good
for my dad who clicks on and executes everything he's prompted with.
Bless him and his viruses.
>
If anyone has a better suggestion to this workaround which will work
with UAC on, please post it here.
>
All the best,
>
Martin
Invent2b Group
>

|||>

Quote:

Originally Posted by

No, I never came as far installing SQL Server. About every second time
I reboot, the machine powers off while Vista is starting. I will probably
change to a different motherboard.
>
--
Erland Sommarskog, SQL Server MVP, esq...@.sommarskog.se
>

How does Vista behave if you install it on a non Vista PC under
Virtual PC 2007?
It does reboot during setup start-up without warning and a blank
screen but else it's much more stable and fine. Just setting up SBS
and some client PCs under Virtual Server on it.
I had that rebooting thing during startup and freezing with three PCs
(non Vista) until it turned out to be a really nasty virus despite
running all sorts of virus checks.
The solution was to actually take the drive out, and stick it as a
slave in another PC with up-to date Free AVG running which actually
detected that bugger.

The only thing that still bugs me with Vista is, and I think it's a
Vista issue, I doesn't list the databases on the SQL Server when
trying to connect (connecting is fine) to an existing instance from
Outlook Business Contact Manager. Checked all the SQL security,
logins, protocols. Any idea?

Cant allocate space for object

Hi!
I'm running mssql 6.5 and I've got a problem with a pretty basic errormessage. I've managed this scenario before, but I't doesnt seem to work this time...
The message is:

Can't allocate space for object '-482' in database 'tempdb' because the 'system' segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment. (Message

What I've done so far is:
dump transaction tempdb with truncate_only
Dump master ...
I've expanded the tempdb device (alter database)

Now I'm starting to run out of ideas...
What's this '-482' (I've also got an error on -386 once)
Anybody have any idea what to do next?

Thanks!!That is the ObjectId of the table in the database.

Cannot start MSSQL Server 7

I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.
When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,
The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Please help.
Could you check the SQL Server error log and let us know if there are any
errors? Also check the event viewer. You can find the error log in MSSQL\Log
folder.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1115975209.034211.143030@.g49g2000cwa.googlegr oups.com...
I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.
When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,
The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Please help.

Cannot start MSSQL Server 7

I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.
When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,
The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Please help.
Check the eventlog as well as SQL Servers errorlog file for error messages from SQL Server.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1115975275.910843.25370@.g44g2000cwa.googlegro ups.com...
>I am not able to start the MSSQL Server service on my system ever since
> I shifted my house and got a new network provider. Earlier, I was on
> the local cable hub, now my computer is on a DSL network. I don't know
> if the network would have something to do with it, but I am just
> providing information for the sake of completeness.
> When I try starting MSSQL Server from the Services applet in the
> Administrative Tools in Control Panel, I get a message saying,
>
> The MSSQLServer service on Local Computer started and then stopped.
> Some services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service.
>
> Please help.
>

Cannot start MSSQL Server 7

I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.

When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,

The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service."

Please help.Water Cooler v2 (wtr_clr@.yahoo.com) writes:
> I am not able to start the MSSQL Server service on my system ever since
> I shifted my house and got a new network provider. Earlier, I was on
> the local cable hub, now my computer is on a DSL network. I don't know
> if the network would have something to do with it, but I am just
> providing information for the sake of completeness.
> When I try starting MSSQL Server from the Services applet in the
> Administrative Tools in Control Panel, I get a message saying,
> The MSSQLServer service on Local Computer started and then stopped.
> Some services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service."

You need to check the SQL Server errorlog, which is in
C:\Progam Files\Microsoft SQL Server\MSSQL\Logs. There is ERRORLOG and
then ERRORLOG.1 to .6, which are the most recent logs.

The only reason I can think of why SQL Server would start and then
stop, is that it runs into a fatal error.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Cannot start MSSQL Server 7

I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.
When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,
The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Please help.
Please do not multi-post. Many people have answered this in different
newsgroups.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1115975222.812999.50190@.g49g2000cwa.googlegro ups.com...
I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.
When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,
The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Please help.

Cannot start MSSQL Server 7

I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.
When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,
The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Please help.Check the eventlog as well as SQL Servers errorlog file for error messages from SQL Server.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1115975275.910843.25370@.g44g2000cwa.googlegroups.com...
>I am not able to start the MSSQL Server service on my system ever since
> I shifted my house and got a new network provider. Earlier, I was on
> the local cable hub, now my computer is on a DSL network. I don't know
> if the network would have something to do with it, but I am just
> providing information for the sake of completeness.
> When I try starting MSSQL Server from the Services applet in the
> Administrative Tools in Control Panel, I get a message saying,
>
> The MSSQLServer service on Local Computer started and then stopped.
> Some services stop automatically if they have no work to do, for
> example, the Performance Logs and Alerts service.
>
> Please help.
>

Cannot start MSSQL Server 7

I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.
When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,
The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Please help.Please do not multi-post. Many people have answered this in different
newsgroups.
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Water Cooler v2" <wtr_clr@.yahoo.com> wrote in message
news:1115975222.812999.50190@.g49g2000cwa.googlegroups.com...
I am not able to start the MSSQL Server service on my system ever since
I shifted my house and got a new network provider. Earlier, I was on
the local cable hub, now my computer is on a DSL network. I don't know
if the network would have something to do with it, but I am just
providing information for the sake of completeness.
When I try starting MSSQL Server from the Services applet in the
Administrative Tools in Control Panel, I get a message saying,
The MSSQLServer service on Local Computer started and then stopped.
Some services stop automatically if they have no work to do, for
example, the Performance Logs and Alerts service.
Please help.

Cannot start Microsoft SQL Server agent & Enterprise manager

Hi:
I am receiving the following error message while trying to open Enterprise
Manager in MSSQL 2000 Server.
A connection could not be established to ABCD
Reason : I/O error 1117(the request could not performed because of an I/O
device error.) detected during read at offset 0x00000000b1e000 in file
'Drive:\Microsoft SQL Server\MSSQL\data\master.mdf'..
Please verify SQL Server is running and check your SQL Server registration
properties (by right cliking on the ABCD node) and try again.
This is a Windows 2000 server (Service Pack 4) + MSSQL 2000 (service Pack
3). The MSSQL server service SQL Server Agent services are running under
local system. This is a Standalone machine.
Help is required on an urgent basis as this is a production server.
With Regards
Mitul
You have a problem with the mdf file for your master database file. Possibly the file is locked by
some other process (like anti-virus). If that is the case, try again. If you are unlucky, the master
mdf file is corrupt for some reason, and you have to go the rebuildm.exe route.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mitul" <Mitul@.discussions.microsoft.com> wrote in message
news:46466B5B-D821-4C07-BD8C-8996EBAD7915@.microsoft.com...
> Hi:
> I am receiving the following error message while trying to open Enterprise
> Manager in MSSQL 2000 Server.
>
> A connection could not be established to ABCD
> Reason : I/O error 1117(the request could not performed because of an I/O
> device error.) detected during read at offset 0x00000000b1e000 in file
> 'Drive:\Microsoft SQL Server\MSSQL\data\master.mdf'..
> Please verify SQL Server is running and check your SQL Server registration
> properties (by right cliking on the ABCD node) and try again.
>
> This is a Windows 2000 server (Service Pack 4) + MSSQL 2000 (service Pack
> 3). The MSSQL server service SQL Server Agent services are running under
> local system. This is a Standalone machine.
> Help is required on an urgent basis as this is a production server.
> With Regards
> Mitul

Cannot start Microsoft SQL Server agent & Enterprise manager

Hi:
I am receiving the following error message while trying to open Enterprise
Manager in MSSQL 2000 Server.
---
A connection could not be established to ABCD
Reason : I/O error 1117(the request could not performed because of an I/O
device error.) detected during read at offset 0x00000000b1e000 in file
'Drive:\Microsoft SQL Server\MSSQL\data\master.mdf'..
Please verify SQL Server is running and check your SQL Server registration
properties (by right cliking on the ABCD node) and try again.
---
This is a Windows 2000 server (Service Pack 4) + MSSQL 2000 (service Pack
3). The MSSQL server service SQL Server Agent services are running under
local system. This is a Standalone machine.
Help is required on an urgent basis as this is a production server.
With Regards
MitulYou have a problem with the mdf file for your master database file. Possibly the file is locked by
some other process (like anti-virus). If that is the case, try again. If you are unlucky, the master
mdf file is corrupt for some reason, and you have to go the rebuildm.exe route.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
http://www.sqlug.se/
"Mitul" <Mitul@.discussions.microsoft.com> wrote in message
news:46466B5B-D821-4C07-BD8C-8996EBAD7915@.microsoft.com...
> Hi:
> I am receiving the following error message while trying to open Enterprise
> Manager in MSSQL 2000 Server.
> ---
> A connection could not be established to ABCD
> Reason : I/O error 1117(the request could not performed because of an I/O
> device error.) detected during read at offset 0x00000000b1e000 in file
> 'Drive:\Microsoft SQL Server\MSSQL\data\master.mdf'..
> Please verify SQL Server is running and check your SQL Server registration
> properties (by right cliking on the ABCD node) and try again.
> ---
> This is a Windows 2000 server (Service Pack 4) + MSSQL 2000 (service Pack
> 3). The MSSQL server service SQL Server Agent services are running under
> local system. This is a Standalone machine.
> Help is required on an urgent basis as this is a production server.
> With Regards
> Mitul

Cannot restore sql user id?

Hi there,
I'm using MSSQL 2000 Standard Edition. I perform a full
database backup and restore to another server (same
version) with same database name.
Every things is OK except the sql user id I created on the
source id. Is not showing in the destination server user
id.
I try to create back the user id in the destination server
with same user name and password but still fail.
What I need to do is delete the user in the database and
recreate plus set back the permissions again!
It is any ways to backup and restore not only the table
and data but also the user id and permission even I
restore to another server?
Thanks.
ChaiWhen you restore or attach a database from another server, the mapping
between syslogins and sysusers for SQL logins gets out-of-sync. The
database userid is still there but it may be either orphaned or mapped to
the wrong login.
You can correct the mismatch with sp_change_users_login. See the Books
Online <tsqlref.chm::/ts_sp_ca-cz_8qzy.htm> for details.
Hope this helps.
Dan Guzman
SQL Server MVP
"Chai" <anonymous@.discussions.microsoft.com> wrote in message
news:89b801c404bb$2df36da0$a401280a@.phx.gbl...
> Hi there,
> I'm using MSSQL 2000 Standard Edition. I perform a full
> database backup and restore to another server (same
> version) with same database name.
> Every things is OK except the sql user id I created on the
> source id. Is not showing in the destination server user
> id.
> I try to create back the user id in the destination server
> with same user name and password but still fail.
> What I need to do is delete the user in the database and
> recreate plus set back the permissions again!
> It is any ways to backup and restore not only the table
> and data but also the user id and permission even I
> restore to another server?
> Thanks.
> Chai

Cannot restore databae successfully

Hi all,
I backed up a database called Citrix_DB through Enterprise Manager from a standalone MSSQL 2000. I tried to restore the DB to another MSSQL 2000 Cluster but failed. Would anyone know how to get it fixed? Thanks a lot. And below is the error message: -
Microsoft SQL-DMO (ODBC SQLState: 42000)
Cannot use file 'e\SQL-Data\MSSQL\data\Citrix_DB_Data.MDF' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. File 'Citrix_DB_Data' cannot be restored to 'e:\SQL-Data\MSSQL\data\Citrix_DB_Data.MDF'. Use WITH MOVE to identify a valid location for the file.
Cannot use file 'e\SQL-Data\MSSQL\data\Citrix_DB_Data.LDF' for clustered server. Only formatted files on which the cluster resource of the server has a dependency can be used. File 'Citrix_DB_Log' cannot be restored to 'e:\SQL-Data\MSSQL\data\Citrix_DB_Data.LDF'. Use WITH MOVE to identify a valid location for the file.
RESTORE DATABASE is terminating abnormally.
Regards,
On your new cluster, you have not made drive E: a dependency for SQL Server.
If you have a shared drive E:, then:
1) Take SQL Server offline
2) Create a disk resource for drive E:
3) Bring up the properties for the SQL Server service and make drive E: a
dependency
4) Bring the SQL Server group online
5) Restore your DB
If you don't have a drive E:, then restore the backup to another drive which
is a dependency for SQL Server.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
..
"vt2006" <someone@.somewhere.com> wrote in message
news:uYNrFdH8GHA.4572@.TK2MSFTNGP02.phx.gbl...
Hi all,
I backed up a database called Citrix_DB through Enterprise Manager from a
standalone MSSQL 2000. I tried to restore the DB to another MSSQL 2000
Cluster but failed. Would anyone know how to get it fixed? Thanks a lot. And
below is the error message: -
Microsoft SQL-DMO (ODBC SQLState: 42000)
Cannot use file 'e\SQL-Data\MSSQL\data\Citrix_DB_Data.MDF' for clustered
server. Only formatted files on which the cluster resource of the server has
a dependency can be used. File 'Citrix_DB_Data' cannot be restored to
'e:\SQL-Data\MSSQL\data\Citrix_DB_Data.MDF'. Use WITH MOVE to identify a
valid location for the file.
Cannot use file 'e\SQL-Data\MSSQL\data\Citrix_DB_Data.LDF' for clustered
server. Only formatted files on which the cluster resource of the server has
a dependency can be used. File 'Citrix_DB_Log' cannot be restored to
'e:\SQL-Data\MSSQL\data\Citrix_DB_Data.LDF'. Use WITH MOVE to identify a
valid location for the file.
RESTORE DATABASE is terminating abnormally.
Regards,

cannot restore a backup database

hi all,

i just learned mssql server and need help form u guys the experts. i made a backup of database but i couldnt restore it into another machine.
the original database name is "employee" and running in mssql 7. the target database is named "employee" as well and running in mssql 2000.
it gave me this message:

Microsoft SQL-DMO (ODBC SQLState: 42000)

Cannot find file ID 2 on the device 'C:\db_bak\employee.dat'.
RESTORE DATABASE is terminating abnormally.

i tried to restore it to another mssql 7 but it gave me the same error message. i dont know how to fix it. in the sql server log, nothing refers to the restore activity. please help...

thanx in advance,

tonjawin mssql2000 i faced a similar problem.

but the problem was solved when i gave the correct path name for the data and log file.(installation directory\data path)