In the table called system files, we have a field called size = Size of the file (in 8-KB pages). And if i look at the physical drive on the explorer this Size is different from the one in the database on system tables. Could someone tell me how to calculate them.
Secondly, i can see that the dumpfile is stored in sysdevices table, but where can i get the size of this dumpfile (.bak) because is always 0 after i dumped the file and again is not 0 on the physical drive of the explorerAbout your 2nd question:
The lines located on the system table only provide the physical location of a logical dump files. The size is 0 in any case.sql
Showing posts with label drive. Show all posts
Showing posts with label drive. Show all posts
Thursday, March 22, 2012
Thursday, March 8, 2012
Database restore problem
A customer's Windows 2000 server would not reboot. They
ran a repair, but the drive letters on the server moved
ahead two spots. The drive letter D is now drive F.
I attempted a restore of a database through Enterprise
Manager, but I get the following error message :
"Device activation error: the physical file name d:\sql
db\otg.mdf: may be incorrect. File 'otg data' cannot be
restored to d:\sql db\otg.mdf'. Use with move to identify
a valid location for the file. Device activation error.
The physical file name 'D:\sql db\otglog.ldf may be
incorrect. File 'otglog' cannot be restored to 'd:\sql
db\otglog.ldf.' Use with move to identify a valid location
for the file. Restore db is terminating abnormally."
The original database files were located on C. A backup of
the database was saved to D.
What can I do to restore this database? Can anyone suggest
a query that restores the database to its previous state?
Thanks for your help.Hello Craig !
If you restore in EM you should change the path where you want to place the
new datafiles from the backup.
Please note, that the directories will NOT be created by EM, they must be
created before restoring the database.
HTH, Jens Süßmeyer.|||Try this:
RESTORE DATABASE otg
FROM DISK= 'c:\wherever the .bak file is'
WITH RECOVERY,replace,
MOVE 'otg_data' TO 'd:\sql_db\otg.mdf',
MOVE 'otgLog' TO 'd:\sql_db\otglog.ldf.'
Make sure you have enough permissions, with OTG imaging database you can use
the sysop user ;)
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Craig Kornacki" <ckornack@.localnet.com> wrote in message
news:034701c36f5b$2e13c320$a301280a@.phx.gbl...
> A customer's Windows 2000 server would not reboot. They
> ran a repair, but the drive letters on the server moved
> ahead two spots. The drive letter D is now drive F.
> I attempted a restore of a database through Enterprise
> Manager, but I get the following error message :
> "Device activation error: the physical file name d:\sql
> db\otg.mdf: may be incorrect. File 'otg data' cannot be
> restored to d:\sql db\otg.mdf'. Use with move to identify
> a valid location for the file. Device activation error.
> The physical file name 'D:\sql db\otglog.ldf may be
> incorrect. File 'otglog' cannot be restored to 'd:\sql
> db\otglog.ldf.' Use with move to identify a valid location
> for the file. Restore db is terminating abnormally."
> The original database files were located on C. A backup of
> the database was saved to D.
> What can I do to restore this database? Can anyone suggest
> a query that restores the database to its previous state?
> Thanks for your help.|||I know it's late, but what I would do is change the Drive letter to the
original drive letter using windows disk manager... This will likely prevent
other mapping kinds of errors from other applications as well.
"Craig Kornacki" <ckornack@.localnet.com> wrote in message
news:034701c36f5b$2e13c320$a301280a@.phx.gbl...
> A customer's Windows 2000 server would not reboot. They
> ran a repair, but the drive letters on the server moved
> ahead two spots. The drive letter D is now drive F.
> I attempted a restore of a database through Enterprise
> Manager, but I get the following error message :
> "Device activation error: the physical file name d:\sql
> db\otg.mdf: may be incorrect. File 'otg data' cannot be
> restored to d:\sql db\otg.mdf'. Use with move to identify
> a valid location for the file. Device activation error.
> The physical file name 'D:\sql db\otglog.ldf may be
> incorrect. File 'otglog' cannot be restored to 'd:\sql
> db\otglog.ldf.' Use with move to identify a valid location
> for the file. Restore db is terminating abnormally."
> The original database files were located on C. A backup of
> the database was saved to D.
> What can I do to restore this database? Can anyone suggest
> a query that restores the database to its previous state?
> Thanks for your help.|||Will this query work even if there is no D drive on the
server?
>--Original Message--
>Try this:
>RESTORE DATABASE otg
>FROM DISK= 'c:\wherever the .bak file is'
> WITH RECOVERY,replace,
> MOVE 'otg_data' TO 'd:\sql_db\otg.mdf',
> MOVE 'otgLog' TO 'd:\sql_db\otglog.ldf.'
>Make sure you have enough permissions, with OTG imaging
database you can use
>the sysop user ;)
>HTH
>--
>Ray Higdon MCSE, MCDBA, CCNA
>--
>"Craig Kornacki" <ckornack@.localnet.com> wrote in message
>news:034701c36f5b$2e13c320$a301280a@.phx.gbl...
>> A customer's Windows 2000 server would not reboot.
They
>> ran a repair, but the drive letters on the server moved
>> ahead two spots. The drive letter D is now drive F.
>> I attempted a restore of a database through Enterprise
>> Manager, but I get the following error message :
>> "Device activation error: the physical file name
d:\sql
>> db\otg.mdf: may be incorrect. File 'otg data' cannot
be
>> restored to d:\sql db\otg.mdf'. Use with move to
identify
>> a valid location for the file. Device activation
error.
>> The physical file name 'D:\sql db\otglog.ldf may be
>> incorrect. File 'otglog' cannot be restored to 'd:\sql
>> db\otglog.ldf.' Use with move to identify a valid
location
>> for the file. Restore db is terminating abnormally."
>> The original database files were located on C. A
backup of
>> the database was saved to D.
>> What can I do to restore this database? Can anyone
suggest
>> a query that restores the database to its previous
state?
>> Thanks for your help.
>
>.
>
ran a repair, but the drive letters on the server moved
ahead two spots. The drive letter D is now drive F.
I attempted a restore of a database through Enterprise
Manager, but I get the following error message :
"Device activation error: the physical file name d:\sql
db\otg.mdf: may be incorrect. File 'otg data' cannot be
restored to d:\sql db\otg.mdf'. Use with move to identify
a valid location for the file. Device activation error.
The physical file name 'D:\sql db\otglog.ldf may be
incorrect. File 'otglog' cannot be restored to 'd:\sql
db\otglog.ldf.' Use with move to identify a valid location
for the file. Restore db is terminating abnormally."
The original database files were located on C. A backup of
the database was saved to D.
What can I do to restore this database? Can anyone suggest
a query that restores the database to its previous state?
Thanks for your help.Hello Craig !
If you restore in EM you should change the path where you want to place the
new datafiles from the backup.
Please note, that the directories will NOT be created by EM, they must be
created before restoring the database.
HTH, Jens Süßmeyer.|||Try this:
RESTORE DATABASE otg
FROM DISK= 'c:\wherever the .bak file is'
WITH RECOVERY,replace,
MOVE 'otg_data' TO 'd:\sql_db\otg.mdf',
MOVE 'otgLog' TO 'd:\sql_db\otglog.ldf.'
Make sure you have enough permissions, with OTG imaging database you can use
the sysop user ;)
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Craig Kornacki" <ckornack@.localnet.com> wrote in message
news:034701c36f5b$2e13c320$a301280a@.phx.gbl...
> A customer's Windows 2000 server would not reboot. They
> ran a repair, but the drive letters on the server moved
> ahead two spots. The drive letter D is now drive F.
> I attempted a restore of a database through Enterprise
> Manager, but I get the following error message :
> "Device activation error: the physical file name d:\sql
> db\otg.mdf: may be incorrect. File 'otg data' cannot be
> restored to d:\sql db\otg.mdf'. Use with move to identify
> a valid location for the file. Device activation error.
> The physical file name 'D:\sql db\otglog.ldf may be
> incorrect. File 'otglog' cannot be restored to 'd:\sql
> db\otglog.ldf.' Use with move to identify a valid location
> for the file. Restore db is terminating abnormally."
> The original database files were located on C. A backup of
> the database was saved to D.
> What can I do to restore this database? Can anyone suggest
> a query that restores the database to its previous state?
> Thanks for your help.|||I know it's late, but what I would do is change the Drive letter to the
original drive letter using windows disk manager... This will likely prevent
other mapping kinds of errors from other applications as well.
"Craig Kornacki" <ckornack@.localnet.com> wrote in message
news:034701c36f5b$2e13c320$a301280a@.phx.gbl...
> A customer's Windows 2000 server would not reboot. They
> ran a repair, but the drive letters on the server moved
> ahead two spots. The drive letter D is now drive F.
> I attempted a restore of a database through Enterprise
> Manager, but I get the following error message :
> "Device activation error: the physical file name d:\sql
> db\otg.mdf: may be incorrect. File 'otg data' cannot be
> restored to d:\sql db\otg.mdf'. Use with move to identify
> a valid location for the file. Device activation error.
> The physical file name 'D:\sql db\otglog.ldf may be
> incorrect. File 'otglog' cannot be restored to 'd:\sql
> db\otglog.ldf.' Use with move to identify a valid location
> for the file. Restore db is terminating abnormally."
> The original database files were located on C. A backup of
> the database was saved to D.
> What can I do to restore this database? Can anyone suggest
> a query that restores the database to its previous state?
> Thanks for your help.|||Will this query work even if there is no D drive on the
server?
>--Original Message--
>Try this:
>RESTORE DATABASE otg
>FROM DISK= 'c:\wherever the .bak file is'
> WITH RECOVERY,replace,
> MOVE 'otg_data' TO 'd:\sql_db\otg.mdf',
> MOVE 'otgLog' TO 'd:\sql_db\otglog.ldf.'
>Make sure you have enough permissions, with OTG imaging
database you can use
>the sysop user ;)
>HTH
>--
>Ray Higdon MCSE, MCDBA, CCNA
>--
>"Craig Kornacki" <ckornack@.localnet.com> wrote in message
>news:034701c36f5b$2e13c320$a301280a@.phx.gbl...
>> A customer's Windows 2000 server would not reboot.
They
>> ran a repair, but the drive letters on the server moved
>> ahead two spots. The drive letter D is now drive F.
>> I attempted a restore of a database through Enterprise
>> Manager, but I get the following error message :
>> "Device activation error: the physical file name
d:\sql
>> db\otg.mdf: may be incorrect. File 'otg data' cannot
be
>> restored to d:\sql db\otg.mdf'. Use with move to
identify
>> a valid location for the file. Device activation
error.
>> The physical file name 'D:\sql db\otglog.ldf may be
>> incorrect. File 'otglog' cannot be restored to 'd:\sql
>> db\otglog.ldf.' Use with move to identify a valid
location
>> for the file. Restore db is terminating abnormally."
>> The original database files were located on C. A
backup of
>> the database was saved to D.
>> What can I do to restore this database? Can anyone
suggest
>> a query that restores the database to its previous
state?
>> Thanks for your help.
>
>.
>
Database Restore from a different db backup
Hi All,
I have the following case.
I have two databases in the same server.
First one: OTG
second one: OTG_MA
Both are backed up in the same drive with name as OTG.bak and
OTG_MA.bak
But I had the situation to restore the OTG_MA database from the
OTG.bak file.
When I used the restore command that was not successful and was
generating errors that I cannot restore from a different backups.
Could anyone please tell me how I can restore database from a
different backup?
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
Thanks a million in advance.
Best regards,
MamunRestore database OTG_MA from disk = 'c:\otg.bak' with
move file1 to 'c:\newloc', move file2 to 'c:\newloc2'
The files must be placed in a location OTHER than the original filenames...
You will also have to force the restore I suspect.
"Mamun" <mamun_ah@.hotmail.com> wrote in message
news:6012e7ab.0309300658.5fb97376@.posting.google.com...
> Hi All,
> I have the following case.
>
> I have two databases in the same server.
> First one: OTG
> second one: OTG_MA
> Both are backed up in the same drive with name as OTG.bak and
> OTG_MA.bak
> But I had the situation to restore the OTG_MA database from the
> OTG.bak file.
> When I used the restore command that was not successful and was
> generating errors that I cannot restore from a different backups.
> Could anyone please tell me how I can restore database from a
> different backup?
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
>
> Thanks a million in advance.
> Best regards,
> Mamun
I have the following case.
I have two databases in the same server.
First one: OTG
second one: OTG_MA
Both are backed up in the same drive with name as OTG.bak and
OTG_MA.bak
But I had the situation to restore the OTG_MA database from the
OTG.bak file.
When I used the restore command that was not successful and was
generating errors that I cannot restore from a different backups.
Could anyone please tell me how I can restore database from a
different backup?
Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
Thanks a million in advance.
Best regards,
MamunRestore database OTG_MA from disk = 'c:\otg.bak' with
move file1 to 'c:\newloc', move file2 to 'c:\newloc2'
The files must be placed in a location OTHER than the original filenames...
You will also have to force the restore I suspect.
"Mamun" <mamun_ah@.hotmail.com> wrote in message
news:6012e7ab.0309300658.5fb97376@.posting.google.com...
> Hi All,
> I have the following case.
>
> I have two databases in the same server.
> First one: OTG
> second one: OTG_MA
> Both are backed up in the same drive with name as OTG.bak and
> OTG_MA.bak
> But I had the situation to restore the OTG_MA database from the
> OTG.bak file.
> When I used the restore command that was not successful and was
> generating errors that I cannot restore from a different backups.
> Could anyone please tell me how I can restore database from a
> different backup?
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 3)
>
> Thanks a million in advance.
> Best regards,
> Mamun
Wednesday, March 7, 2012
Database restore after system Rebuild
Hi,
I have one SQL server where my databases where kept on the D drive, and
the transaction logs where on a physically seperate C drive. The D
drive became corrupted and I could not start SQL Server because the
master database was corrupt. So, I had to use the RebuildDM.exe to
rebuild the system tables. I have the log files sitting on the C
drive, but I never had a chance to back them up to the most recent
point today because I could not get into SQL Server until I rebuild it.
Now what I would like to do is just restore the databases and then use
the logs that are sitting on C, but the only way it seems that I can do
this is by backing up the transaction logs first, which I did not have
a chance to do. Is there anyway I can take a backup of my DB and tell
it to use the transaction logs that already exists so that it can apply
any missing transactions?
I forgot to mention, this box is windows server 2003 with sql server
2000 SP4
|||Doh, after hours of searching I found the answer right after posting
this. For anyone who has this problem, look here
http://support.microsoft.com/default...;EN-US;Q253817
I have one SQL server where my databases where kept on the D drive, and
the transaction logs where on a physically seperate C drive. The D
drive became corrupted and I could not start SQL Server because the
master database was corrupt. So, I had to use the RebuildDM.exe to
rebuild the system tables. I have the log files sitting on the C
drive, but I never had a chance to back them up to the most recent
point today because I could not get into SQL Server until I rebuild it.
Now what I would like to do is just restore the databases and then use
the logs that are sitting on C, but the only way it seems that I can do
this is by backing up the transaction logs first, which I did not have
a chance to do. Is there anyway I can take a backup of my DB and tell
it to use the transaction logs that already exists so that it can apply
any missing transactions?
I forgot to mention, this box is windows server 2003 with sql server
2000 SP4
|||Doh, after hours of searching I found the answer right after posting
this. For anyone who has this problem, look here
http://support.microsoft.com/default...;EN-US;Q253817
Database restore after system Rebuild
Hi,
I have one SQL server where my databases where kept on the D drive, and
the transaction logs where on a physically seperate C drive. The D
drive became corrupted and I could not start SQL Server because the
master database was corrupt. So, I had to use the RebuildDM.exe to
rebuild the system tables. I have the log files sitting on the C
drive, but I never had a chance to back them up to the most recent
point today because I could not get into SQL Server until I rebuild it.
Now what I would like to do is just restore the databases and then use
the logs that are sitting on C, but the only way it seems that I can do
this is by backing up the transaction logs first, which I did not have
a chance to do. Is there anyway I can take a backup of my DB and tell
it to use the transaction logs that already exists so that it can apply
any missing transactions?I forgot to mention, this box is windows server 2003 with sql server
2000 SP4|||Doh, after hours of searching I found the answer right after posting
this. For anyone who has this problem, look here
http://support.microsoft.com/defaul...b;EN-US;Q253817
I have one SQL server where my databases where kept on the D drive, and
the transaction logs where on a physically seperate C drive. The D
drive became corrupted and I could not start SQL Server because the
master database was corrupt. So, I had to use the RebuildDM.exe to
rebuild the system tables. I have the log files sitting on the C
drive, but I never had a chance to back them up to the most recent
point today because I could not get into SQL Server until I rebuild it.
Now what I would like to do is just restore the databases and then use
the logs that are sitting on C, but the only way it seems that I can do
this is by backing up the transaction logs first, which I did not have
a chance to do. Is there anyway I can take a backup of my DB and tell
it to use the transaction logs that already exists so that it can apply
any missing transactions?I forgot to mention, this box is windows server 2003 with sql server
2000 SP4|||Doh, after hours of searching I found the answer right after posting
this. For anyone who has this problem, look here
http://support.microsoft.com/defaul...b;EN-US;Q253817
Database restore after system Rebuild
Hi,
I have one SQL server where my databases where kept on the D drive, and
the transaction logs where on a physically seperate C drive. The D
drive became corrupted and I could not start SQL Server because the
master database was corrupt. So, I had to use the RebuildDM.exe to
rebuild the system tables. I have the log files sitting on the C
drive, but I never had a chance to back them up to the most recent
point today because I could not get into SQL Server until I rebuild it.
Now what I would like to do is just restore the databases and then use
the logs that are sitting on C, but the only way it seems that I can do
this is by backing up the transaction logs first, which I did not have
a chance to do. Is there anyway I can take a backup of my DB and tell
it to use the transaction logs that already exists so that it can apply
any missing transactions?I forgot to mention, this box is windows server 2003 with sql server
2000 SP4|||Doh, after hours of searching I found the answer right after posting
this. For anyone who has this problem, look here
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q253817
I have one SQL server where my databases where kept on the D drive, and
the transaction logs where on a physically seperate C drive. The D
drive became corrupted and I could not start SQL Server because the
master database was corrupt. So, I had to use the RebuildDM.exe to
rebuild the system tables. I have the log files sitting on the C
drive, but I never had a chance to back them up to the most recent
point today because I could not get into SQL Server until I rebuild it.
Now what I would like to do is just restore the databases and then use
the logs that are sitting on C, but the only way it seems that I can do
this is by backing up the transaction logs first, which I did not have
a chance to do. Is there anyway I can take a backup of my DB and tell
it to use the transaction logs that already exists so that it can apply
any missing transactions?I forgot to mention, this box is windows server 2003 with sql server
2000 SP4|||Doh, after hours of searching I found the answer right after posting
this. For anyone who has this problem, look here
http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q253817
Database Restoration
Hi!
Could anyone please advice me on whether I could restore
database from a map drive ? This is due to space
limitation of the existing server...
Any other suggestions would be much appreciated..
TIAIt generally work (I've seen some issues with backup/restore over the
network, mainly for larger backups). Worth a try. Make sure that the SQL
Server service account has permissions on the share, and address using UNC
naming.
--
Tibor Karaszi
"NG" <angiecmf@.hotmail.com> wrote in message
news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
> Hi!
> Could anyone please advice me on whether I could restore
> database from a map drive ? This is due to space
> limitation of the existing server...
> Any other suggestions would be much appreciated..
> TIA|||Could you provide me the steps cause i have tried it and
could not view the map drive from Enterprise Manager...
on NT4 platform MSSQL 7.0 server.
TIA
>--Original Message--
>It generally work (I've seen some issues with
backup/restore over the
>network, mainly for larger backups). Worth a try. Make
sure that the SQL
>Server service account has permissions on the share, and
address using UNC
>naming.
>--
>Tibor Karaszi
>
>"NG" <angiecmf@.hotmail.com> wrote in message
>news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
>> Hi!
>> Could anyone please advice me on whether I could restore
>> database from a map drive ? This is due to space
>> limitation of the existing server...
>> Any other suggestions would be much appreciated..
>> TIA
>
>.
>|||Don't use mapped drives, just enter the path as an UNC path:
\\servername\sharename\filename
--
Tibor Karaszi
"NG" <angiecmf@.hotmail.com> wrote in message
news:09bf01c3a272$9ec2e4d0$a301280a@.phx.gbl...
> Could you provide me the steps cause i have tried it and
> could not view the map drive from Enterprise Manager...
> on NT4 platform MSSQL 7.0 server.
> TIA
> >--Original Message--
> >It generally work (I've seen some issues with
> backup/restore over the
> >network, mainly for larger backups). Worth a try. Make
> sure that the SQL
> >Server service account has permissions on the share, and
> address using UNC
> >naming.
> >
> >--
> >Tibor Karaszi
> >
> >
> >"NG" <angiecmf@.hotmail.com> wrote in message
> >news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
> >> Hi!
> >>
> >> Could anyone please advice me on whether I could restore
> >> database from a map drive ? This is due to space
> >> limitation of the existing server...
> >> Any other suggestions would be much appreciated..
> >> TIA
> >
> >
> >.
> >|||i encountered error "Unable to verify the existence of the
backup file location". Do you want to use the backup file
location anyway? and
Microsoft SQL-DMO (ODBC SQLState: 42000)
"Cannot open backup
device '\\Etax_media\temp\tna_sen.bak'. Device error or
device off-line. Backup or restore operation terminating
abnormally"
Please help! Thanks
>--Original Message--
>Don't use mapped drives, just enter the path as an UNC
path:
>\\servername\sharename\filename
>--
>Tibor Karaszi
>
>"NG" <angiecmf@.hotmail.com> wrote in message
>news:09bf01c3a272$9ec2e4d0$a301280a@.phx.gbl...
>> Could you provide me the steps cause i have tried it and
>> could not view the map drive from Enterprise Manager...
>> on NT4 platform MSSQL 7.0 server.
>> TIA
>> >--Original Message--
>> >It generally work (I've seen some issues with
>> backup/restore over the
>> >network, mainly for larger backups). Worth a try. Make
>> sure that the SQL
>> >Server service account has permissions on the share,
and
>> address using UNC
>> >naming.
>> >
>> >--
>> >Tibor Karaszi
>> >
>> >
>> >"NG" <angiecmf@.hotmail.com> wrote in message
>> >news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
>> >> Hi!
>> >>
>> >> Could anyone please advice me on whether I could
restore
>> >> database from a map drive ? This is due to space
>> >> limitation of the existing server...
>> >> Any other suggestions would be much appreciated..
>> >> TIA
>> >
>> >
>> >.
>> >
>
>.
>|||The first message is some tool (or rather, API) message, not an engine
message. The second is an engine message. It seems that the path is
incorrect or that the SQL Server service account don't have permissions on
the share.
--
Tibor Karaszi
"NG" <angiecmf@.hotmail.com> wrote in message
news:0aff01c3a2ab$d4f047d0$a401280a@.phx.gbl...
> i encountered error "Unable to verify the existence of the
> backup file location". Do you want to use the backup file
> location anyway? and
> Microsoft SQL-DMO (ODBC SQLState: 42000)
> "Cannot open backup
> device '\\Etax_media\temp\tna_sen.bak'. Device error or
> device off-line. Backup or restore operation terminating
> abnormally"
> Please help! Thanks
> >--Original Message--
> >Don't use mapped drives, just enter the path as an UNC
> path:
> >\\servername\sharename\filename
> >
> >--
> >Tibor Karaszi
> >
> >
> >"NG" <angiecmf@.hotmail.com> wrote in message
> >news:09bf01c3a272$9ec2e4d0$a301280a@.phx.gbl...
> >> Could you provide me the steps cause i have tried it and
> >> could not view the map drive from Enterprise Manager...
> >> on NT4 platform MSSQL 7.0 server.
> >> TIA
> >>
> >> >--Original Message--
> >> >It generally work (I've seen some issues with
> >> backup/restore over the
> >> >network, mainly for larger backups). Worth a try. Make
> >> sure that the SQL
> >> >Server service account has permissions on the share,
> and
> >> address using UNC
> >> >naming.
> >> >
> >> >--
> >> >Tibor Karaszi
> >> >
> >> >
> >> >"NG" <angiecmf@.hotmail.com> wrote in message
> >> >news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
> >> >> Hi!
> >> >>
> >> >> Could anyone please advice me on whether I could
> restore
> >> >> database from a map drive ? This is due to space
> >> >> limitation of the existing server...
> >> >> Any other suggestions would be much appreciated..
> >> >> TIA
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >
Could anyone please advice me on whether I could restore
database from a map drive ? This is due to space
limitation of the existing server...
Any other suggestions would be much appreciated..
TIAIt generally work (I've seen some issues with backup/restore over the
network, mainly for larger backups). Worth a try. Make sure that the SQL
Server service account has permissions on the share, and address using UNC
naming.
--
Tibor Karaszi
"NG" <angiecmf@.hotmail.com> wrote in message
news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
> Hi!
> Could anyone please advice me on whether I could restore
> database from a map drive ? This is due to space
> limitation of the existing server...
> Any other suggestions would be much appreciated..
> TIA|||Could you provide me the steps cause i have tried it and
could not view the map drive from Enterprise Manager...
on NT4 platform MSSQL 7.0 server.
TIA
>--Original Message--
>It generally work (I've seen some issues with
backup/restore over the
>network, mainly for larger backups). Worth a try. Make
sure that the SQL
>Server service account has permissions on the share, and
address using UNC
>naming.
>--
>Tibor Karaszi
>
>"NG" <angiecmf@.hotmail.com> wrote in message
>news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
>> Hi!
>> Could anyone please advice me on whether I could restore
>> database from a map drive ? This is due to space
>> limitation of the existing server...
>> Any other suggestions would be much appreciated..
>> TIA
>
>.
>|||Don't use mapped drives, just enter the path as an UNC path:
\\servername\sharename\filename
--
Tibor Karaszi
"NG" <angiecmf@.hotmail.com> wrote in message
news:09bf01c3a272$9ec2e4d0$a301280a@.phx.gbl...
> Could you provide me the steps cause i have tried it and
> could not view the map drive from Enterprise Manager...
> on NT4 platform MSSQL 7.0 server.
> TIA
> >--Original Message--
> >It generally work (I've seen some issues with
> backup/restore over the
> >network, mainly for larger backups). Worth a try. Make
> sure that the SQL
> >Server service account has permissions on the share, and
> address using UNC
> >naming.
> >
> >--
> >Tibor Karaszi
> >
> >
> >"NG" <angiecmf@.hotmail.com> wrote in message
> >news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
> >> Hi!
> >>
> >> Could anyone please advice me on whether I could restore
> >> database from a map drive ? This is due to space
> >> limitation of the existing server...
> >> Any other suggestions would be much appreciated..
> >> TIA
> >
> >
> >.
> >|||i encountered error "Unable to verify the existence of the
backup file location". Do you want to use the backup file
location anyway? and
Microsoft SQL-DMO (ODBC SQLState: 42000)
"Cannot open backup
device '\\Etax_media\temp\tna_sen.bak'. Device error or
device off-line. Backup or restore operation terminating
abnormally"
Please help! Thanks
>--Original Message--
>Don't use mapped drives, just enter the path as an UNC
path:
>\\servername\sharename\filename
>--
>Tibor Karaszi
>
>"NG" <angiecmf@.hotmail.com> wrote in message
>news:09bf01c3a272$9ec2e4d0$a301280a@.phx.gbl...
>> Could you provide me the steps cause i have tried it and
>> could not view the map drive from Enterprise Manager...
>> on NT4 platform MSSQL 7.0 server.
>> TIA
>> >--Original Message--
>> >It generally work (I've seen some issues with
>> backup/restore over the
>> >network, mainly for larger backups). Worth a try. Make
>> sure that the SQL
>> >Server service account has permissions on the share,
and
>> address using UNC
>> >naming.
>> >
>> >--
>> >Tibor Karaszi
>> >
>> >
>> >"NG" <angiecmf@.hotmail.com> wrote in message
>> >news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
>> >> Hi!
>> >>
>> >> Could anyone please advice me on whether I could
restore
>> >> database from a map drive ? This is due to space
>> >> limitation of the existing server...
>> >> Any other suggestions would be much appreciated..
>> >> TIA
>> >
>> >
>> >.
>> >
>
>.
>|||The first message is some tool (or rather, API) message, not an engine
message. The second is an engine message. It seems that the path is
incorrect or that the SQL Server service account don't have permissions on
the share.
--
Tibor Karaszi
"NG" <angiecmf@.hotmail.com> wrote in message
news:0aff01c3a2ab$d4f047d0$a401280a@.phx.gbl...
> i encountered error "Unable to verify the existence of the
> backup file location". Do you want to use the backup file
> location anyway? and
> Microsoft SQL-DMO (ODBC SQLState: 42000)
> "Cannot open backup
> device '\\Etax_media\temp\tna_sen.bak'. Device error or
> device off-line. Backup or restore operation terminating
> abnormally"
> Please help! Thanks
> >--Original Message--
> >Don't use mapped drives, just enter the path as an UNC
> path:
> >\\servername\sharename\filename
> >
> >--
> >Tibor Karaszi
> >
> >
> >"NG" <angiecmf@.hotmail.com> wrote in message
> >news:09bf01c3a272$9ec2e4d0$a301280a@.phx.gbl...
> >> Could you provide me the steps cause i have tried it and
> >> could not view the map drive from Enterprise Manager...
> >> on NT4 platform MSSQL 7.0 server.
> >> TIA
> >>
> >> >--Original Message--
> >> >It generally work (I've seen some issues with
> >> backup/restore over the
> >> >network, mainly for larger backups). Worth a try. Make
> >> sure that the SQL
> >> >Server service account has permissions on the share,
> and
> >> address using UNC
> >> >naming.
> >> >
> >> >--
> >> >Tibor Karaszi
> >> >
> >> >
> >> >"NG" <angiecmf@.hotmail.com> wrote in message
> >> >news:0a0001c3a1ed$b56a27a0$a601280a@.phx.gbl...
> >> >> Hi!
> >> >>
> >> >> Could anyone please advice me on whether I could
> restore
> >> >> database from a map drive ? This is due to space
> >> >> limitation of the existing server...
> >> >> Any other suggestions would be much appreciated..
> >> >> TIA
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >
Saturday, February 25, 2012
Database removable
Hello,is possible attach and use the mdf exists in a pen drive or an usb
hard disk ?
What commands are involved in this operation ?
Thanks in advance.
I have a lot of DB allocated on my USB (or Firewire) external disk; even a
pen drive is managed by the OS as an external, removable disk.
The only attention you hav to pay is to remember detach you removable
database when you suppose the next startup of your PC will be without the
external disks containing your databases.
When you need to use such databases you'll attach it again
Gilberto
"Luis Tarzia" wrote:
> Hello,is possible attach and use the mdf exists in a pen drive or an usb
> hard disk ?
> What commands are involved in this operation ?
> Thanks in advance.
>
>
|||I attach the mdf with the sp_attachd but when i execute any sql command the
sql mark an error of access a memory and exit.
"Gilberto Zampatti" <GilbertoZampatti@.discussions.microsoft.com> escribi en
el mensaje news:5BF5A51B-83A5-4A23-B540-B104BBCDD7AC@.microsoft.com...
> I have a lot of DB allocated on my USB (or Firewire) external disk; even
a[vbcol=seagreen]
> pen drive is managed by the OS as an external, removable disk.
> The only attention you hav to pay is to remember detach you removable
> database when you suppose the next startup of your PC will be without the
> external disks containing your databases.
> When you need to use such databases you'll attach it again
> Gilberto
> "Luis Tarzia" wrote:
hard disk ?
What commands are involved in this operation ?
Thanks in advance.
I have a lot of DB allocated on my USB (or Firewire) external disk; even a
pen drive is managed by the OS as an external, removable disk.
The only attention you hav to pay is to remember detach you removable
database when you suppose the next startup of your PC will be without the
external disks containing your databases.
When you need to use such databases you'll attach it again
Gilberto
"Luis Tarzia" wrote:
> Hello,is possible attach and use the mdf exists in a pen drive or an usb
> hard disk ?
> What commands are involved in this operation ?
> Thanks in advance.
>
>
|||I attach the mdf with the sp_attachd but when i execute any sql command the
sql mark an error of access a memory and exit.
"Gilberto Zampatti" <GilbertoZampatti@.discussions.microsoft.com> escribi en
el mensaje news:5BF5A51B-83A5-4A23-B540-B104BBCDD7AC@.microsoft.com...
> I have a lot of DB allocated on my USB (or Firewire) external disk; even
a[vbcol=seagreen]
> pen drive is managed by the OS as an external, removable disk.
> The only attention you hav to pay is to remember detach you removable
> database when you suppose the next startup of your PC will be without the
> external disks containing your databases.
> When you need to use such databases you'll attach it again
> Gilberto
> "Luis Tarzia" wrote:
Database removable
Hello,is possible attach and use the mdf exists in a pen drive or an usb
hard disk ?
What commands are involved in this operation '
Thanks in advance.I have a lot of DB allocated on my USB (or Firewire) external disk; even a
pen drive is managed by the OS as an external, removable disk.
The only attention you hav to pay is to remember detach you removable
database when you suppose the next startup of your PC will be without the
external disks containing your databases.
When you need to use such databases you'll attach it again
Gilberto
"Luis Tarzia" wrote:
> Hello,is possible attach and use the mdf exists in a pen drive or an usb
> hard disk ?
> What commands are involved in this operation '
> Thanks in advance.
>
>|||I attach the mdf with the sp_attachd but when i execute any sql command the
sql mark an error of access a memory and exit.
"Gilberto Zampatti" <GilbertoZampatti@.discussions.microsoft.com> escribi en
el mensaje news:5BF5A51B-83A5-4A23-B540-B104BBCDD7AC@.microsoft.com...
> I have a lot of DB allocated on my USB (or Firewire) external disk; even
a[vbcol=seagreen]
> pen drive is managed by the OS as an external, removable disk.
> The only attention you hav to pay is to remember detach you removable
> database when you suppose the next startup of your PC will be without the
> external disks containing your databases.
> When you need to use such databases you'll attach it again
> Gilberto
> "Luis Tarzia" wrote:
>
hard disk ?
What commands are involved in this operation '
Thanks in advance.I have a lot of DB allocated on my USB (or Firewire) external disk; even a
pen drive is managed by the OS as an external, removable disk.
The only attention you hav to pay is to remember detach you removable
database when you suppose the next startup of your PC will be without the
external disks containing your databases.
When you need to use such databases you'll attach it again
Gilberto
"Luis Tarzia" wrote:
> Hello,is possible attach and use the mdf exists in a pen drive or an usb
> hard disk ?
> What commands are involved in this operation '
> Thanks in advance.
>
>|||I attach the mdf with the sp_attachd but when i execute any sql command the
sql mark an error of access a memory and exit.
"Gilberto Zampatti" <GilbertoZampatti@.discussions.microsoft.com> escribi en
el mensaje news:5BF5A51B-83A5-4A23-B540-B104BBCDD7AC@.microsoft.com...
> I have a lot of DB allocated on my USB (or Firewire) external disk; even
a[vbcol=seagreen]
> pen drive is managed by the OS as an external, removable disk.
> The only attention you hav to pay is to remember detach you removable
> database when you suppose the next startup of your PC will be without the
> external disks containing your databases.
> When you need to use such databases you'll attach it again
> Gilberto
> "Luis Tarzia" wrote:
>
Database removable
Hello,is possible attach and use the mdf exists in a pen drive or an usb
hard disk ?
What commands are involved in this operation '
Thanks in advance.I have a lot of DB allocated on my USB (or Firewire) external disk; even a
pen drive is managed by the OS as an external, removable disk.
The only attention you hav to pay is to remember detach you removable
database when you suppose the next startup of your PC will be without the
external disks containing your databases.
When you need to use such databases you'll attach it again
Gilberto
"Luis Tarzia" wrote:
> Hello,is possible attach and use the mdf exists in a pen drive or an usb
> hard disk ?
> What commands are involved in this operation '
> Thanks in advance.
>
>|||I attach the mdf with the sp_attachd but when i execute any sql command the
sql mark an error of access a memory and exit.
"Gilberto Zampatti" <GilbertoZampatti@.discussions.microsoft.com> escribió en
el mensaje news:5BF5A51B-83A5-4A23-B540-B104BBCDD7AC@.microsoft.com...
> I have a lot of DB allocated on my USB (or Firewire) external disk; even
a
> pen drive is managed by the OS as an external, removable disk.
> The only attention you hav to pay is to remember detach you removable
> database when you suppose the next startup of your PC will be without the
> external disks containing your databases.
> When you need to use such databases you'll attach it again
> Gilberto
> "Luis Tarzia" wrote:
> > Hello,is possible attach and use the mdf exists in a pen drive or an usb
> > hard disk ?
> > What commands are involved in this operation '
> > Thanks in advance.
> >
> >
> >
hard disk ?
What commands are involved in this operation '
Thanks in advance.I have a lot of DB allocated on my USB (or Firewire) external disk; even a
pen drive is managed by the OS as an external, removable disk.
The only attention you hav to pay is to remember detach you removable
database when you suppose the next startup of your PC will be without the
external disks containing your databases.
When you need to use such databases you'll attach it again
Gilberto
"Luis Tarzia" wrote:
> Hello,is possible attach and use the mdf exists in a pen drive or an usb
> hard disk ?
> What commands are involved in this operation '
> Thanks in advance.
>
>|||I attach the mdf with the sp_attachd but when i execute any sql command the
sql mark an error of access a memory and exit.
"Gilberto Zampatti" <GilbertoZampatti@.discussions.microsoft.com> escribió en
el mensaje news:5BF5A51B-83A5-4A23-B540-B104BBCDD7AC@.microsoft.com...
> I have a lot of DB allocated on my USB (or Firewire) external disk; even
a
> pen drive is managed by the OS as an external, removable disk.
> The only attention you hav to pay is to remember detach you removable
> database when you suppose the next startup of your PC will be without the
> external disks containing your databases.
> When you need to use such databases you'll attach it again
> Gilberto
> "Luis Tarzia" wrote:
> > Hello,is possible attach and use the mdf exists in a pen drive or an usb
> > hard disk ?
> > What commands are involved in this operation '
> > Thanks in advance.
> >
> >
> >
Friday, February 24, 2012
Database recovery issue
Hi guys
I am trying to open a database which is on a shared drive. The database is
stored in the 'my network places'. Now when I try to copy the database into
my hard disk, it says "sharing violation, file in use' whereas nobody else is
using it except me.
SQL does not recognise the shared path as it is installed locally on my hard
disk.
Im using sql server 2005
PLease help guys
I'm not clear on what you mean by the last part of "SQL does
not recognise the shared path as it is installed locally on
my hard disk". You don't want to use network shares for SQL
Server data, log files.
In terms of not being able to access the files to copy to
your hard drive, you can use FileMon from sysinternals to
see what process or what user has the files in use:
http://www.sysinternals.com/Utilities/Filemon.html
-Sue
On Sun, 5 Nov 2006 11:39:02 -0800, mita
<mita@.discussions.microsoft.com> wrote:
>Hi guys
>I am trying to open a database which is on a shared drive. The database is
>stored in the 'my network places'. Now when I try to copy the database into
>my hard disk, it says "sharing violation, file in use' whereas nobody else is
>using it except me.
>SQL does not recognise the shared path as it is installed locally on my hard
>disk.
>Im using sql server 2005
>PLease help guys
I am trying to open a database which is on a shared drive. The database is
stored in the 'my network places'. Now when I try to copy the database into
my hard disk, it says "sharing violation, file in use' whereas nobody else is
using it except me.
SQL does not recognise the shared path as it is installed locally on my hard
disk.
Im using sql server 2005
PLease help guys
I'm not clear on what you mean by the last part of "SQL does
not recognise the shared path as it is installed locally on
my hard disk". You don't want to use network shares for SQL
Server data, log files.
In terms of not being able to access the files to copy to
your hard drive, you can use FileMon from sysinternals to
see what process or what user has the files in use:
http://www.sysinternals.com/Utilities/Filemon.html
-Sue
On Sun, 5 Nov 2006 11:39:02 -0800, mita
<mita@.discussions.microsoft.com> wrote:
>Hi guys
>I am trying to open a database which is on a shared drive. The database is
>stored in the 'my network places'. Now when I try to copy the database into
>my hard disk, it says "sharing violation, file in use' whereas nobody else is
>using it except me.
>SQL does not recognise the shared path as it is installed locally on my hard
>disk.
>Im using sql server 2005
>PLease help guys
Database Recovery Issue
We had a hard drive crash on one of our servers. There are no backups of the
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). Any
suggestions would be greatly appreciated.There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). Any
suggestions would be greatly appreciated.There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.
Database Recovery Issue
We had a hard drive crash on one of our servers. There are no backups of the
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). Any
suggestions would be greatly appreciated.
There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). Any
suggestions would be greatly appreciated.
There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.
Database Recovery Issue
We had a hard drive crash on one of our servers. There are no backups of the
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). An
y
suggestions would be greatly appreciated.There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.
database available but we were able to recover the MDF and LDf for the only
database that was on the server. The server had to be rebuilt and SQL
reinstalled. The question I have, is there a way to recover this database
using the MDF and LDF files. I tried using the sp_attach_db command but
without much success (don't know if I used the wrong parameters or what). An
y
suggestions would be greatly appreciated.There are several possibilities depending on the state of the database and
files involved. Your best bet is to contact PSS
(http://support.microsoft.com) who will be able to help you get up and
running again (and fix your backup process, of course :-)
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"MACason" <MACason@.discussions.microsoft.com> wrote in message
news:987BCD70-4AD9-42A6-AF66-CBB37EECB647@.microsoft.com...
> We had a hard drive crash on one of our servers. There are no backups of
the
> database available but we were able to recover the MDF and LDf for the
only
> database that was on the server. The server had to be rebuilt and SQL
> reinstalled. The question I have, is there a way to recover this database
> using the MDF and LDF files. I tried using the sp_attach_db command but
> without much success (don't know if I used the wrong parameters or what).
Any
> suggestions would be greatly appreciated.
Database recovery
Had a server crash totaly. Rebuilt a new server with
different drive partitions. Reinstalled SQL 7 and then
restored master from backup. SQL will not start because
it is looking for model,msdb, temp in the original
location which no longer exists. Had this problem on 2000
as well. Any suggestions?You can try to start SQL Server with two undocumented trace flags:
Trace Flag 3608 does not recover any database except the master
Trace Flag 3609 start without TempDB.
Start the service with -f (minimal configuration) option as well.
If this works, attach the databases, except tempdb. Try to move tempdb to a
new location as described in the "Expanding a Database" topic in BOL
(mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\cr
eatedb.chm::/cm_8_des_03_71d1.htm). If this works, restart SQL Server.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Franco" <franco.carusi@.sbs.siemens.co.za> wrote in message
news:018401c37cdc$b94d0df0$a001280a@.phx.gbl...
> Had a server crash totaly. Rebuilt a new server with
> different drive partitions. Reinstalled SQL 7 and then
> restored master from backup. SQL will not start because
> it is looking for model,msdb, temp in the original
> location which no longer exists. Had this problem on 2000
> as well. Any suggestions?|||Unfortunately a list of undocumented trace flags does not exist in public,
otherwise they would not be undocumented. What you can do is not to restore
the master db after reinstallation, you can just use the "new" one and
attach other databases. But you would have to recreate all logins, map them
to db users etc. The other solution is to call MS support. I think they have
the list:-)
Have you tried with all three, the -f option and both trace flags mentioned
at the same time? I remember few years ago when I had some problems with
tempdb these options forced SQL Sever to skip recovery for all databases,
not just model.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Franco" <franco.carusi@.sbs.siemens.co.za> wrote in message
news:08d101c37cf0$7f7ed680$a401280a@.phx.gbl...
> Tried it and does not work - from the error log it seems
> as if it skipped the model database but is still looking
> for msdb and temp. (previously looking for msdb and
> model). Definately looks as if a step closer. Do you know
> where I can get a list of trace flags?
> >--Original Message--
> >You can try to start SQL Server with two undocumented
> trace flags:
> >Trace Flag 3608 does not recover any database except the
> master
> >Trace Flag 3609 start without TempDB.
> >Start the service with -f (minimal configuration) option
> as well.
> >If this works, attach the databases, except tempdb. Try
> to move tempdb to a
> >new location as described in the "Expanding a Database"
> topic in BOL
> >(mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%
> 20Server\80\Tools\Books\cr
> >eatedb.chm::/cm_8_des_03_71d1.htm). If this works,
> restart SQL Server.
> >
> >--
> >Dejan Sarka, SQL Server MVP
> >FAQ from Neil & others at: http://www.sqlserverfaq.com
> >Please reply only to the newsgroups.
> >PASS - the definitive, global community
> >for SQL Server professionals - http://www.sqlpass.org
> >
> >"Franco" <franco.carusi@.sbs.siemens.co.za> wrote in
> message
> >news:018401c37cdc$b94d0df0$a001280a@.phx.gbl...
> >> Had a server crash totaly. Rebuilt a new server with
> >> different drive partitions. Reinstalled SQL 7 and then
> >> restored master from backup. SQL will not start because
> >> it is looking for model,msdb, temp in the original
> >> location which no longer exists. Had this problem on
> 2000
> >> as well. Any suggestions?
> >
> >
> >.
> >
different drive partitions. Reinstalled SQL 7 and then
restored master from backup. SQL will not start because
it is looking for model,msdb, temp in the original
location which no longer exists. Had this problem on 2000
as well. Any suggestions?You can try to start SQL Server with two undocumented trace flags:
Trace Flag 3608 does not recover any database except the master
Trace Flag 3609 start without TempDB.
Start the service with -f (minimal configuration) option as well.
If this works, attach the databases, except tempdb. Try to move tempdb to a
new location as described in the "Expanding a Database" topic in BOL
(mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%20Server\80\Tools\Books\cr
eatedb.chm::/cm_8_des_03_71d1.htm). If this works, restart SQL Server.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Franco" <franco.carusi@.sbs.siemens.co.za> wrote in message
news:018401c37cdc$b94d0df0$a001280a@.phx.gbl...
> Had a server crash totaly. Rebuilt a new server with
> different drive partitions. Reinstalled SQL 7 and then
> restored master from backup. SQL will not start because
> it is looking for model,msdb, temp in the original
> location which no longer exists. Had this problem on 2000
> as well. Any suggestions?|||Unfortunately a list of undocumented trace flags does not exist in public,
otherwise they would not be undocumented. What you can do is not to restore
the master db after reinstallation, you can just use the "new" one and
attach other databases. But you would have to recreate all logins, map them
to db users etc. The other solution is to call MS support. I think they have
the list:-)
Have you tried with all three, the -f option and both trace flags mentioned
at the same time? I remember few years ago when I had some problems with
tempdb these options forced SQL Sever to skip recovery for all databases,
not just model.
--
Dejan Sarka, SQL Server MVP
FAQ from Neil & others at: http://www.sqlserverfaq.com
Please reply only to the newsgroups.
PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Franco" <franco.carusi@.sbs.siemens.co.za> wrote in message
news:08d101c37cf0$7f7ed680$a401280a@.phx.gbl...
> Tried it and does not work - from the error log it seems
> as if it skipped the model database but is still looking
> for msdb and temp. (previously looking for msdb and
> model). Definately looks as if a step closer. Do you know
> where I can get a list of trace flags?
> >--Original Message--
> >You can try to start SQL Server with two undocumented
> trace flags:
> >Trace Flag 3608 does not recover any database except the
> master
> >Trace Flag 3609 start without TempDB.
> >Start the service with -f (minimal configuration) option
> as well.
> >If this works, attach the databases, except tempdb. Try
> to move tempdb to a
> >new location as described in the "Expanding a Database"
> topic in BOL
> >(mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%
> 20Server\80\Tools\Books\cr
> >eatedb.chm::/cm_8_des_03_71d1.htm). If this works,
> restart SQL Server.
> >
> >--
> >Dejan Sarka, SQL Server MVP
> >FAQ from Neil & others at: http://www.sqlserverfaq.com
> >Please reply only to the newsgroups.
> >PASS - the definitive, global community
> >for SQL Server professionals - http://www.sqlpass.org
> >
> >"Franco" <franco.carusi@.sbs.siemens.co.za> wrote in
> message
> >news:018401c37cdc$b94d0df0$a001280a@.phx.gbl...
> >> Had a server crash totaly. Rebuilt a new server with
> >> different drive partitions. Reinstalled SQL 7 and then
> >> restored master from backup. SQL will not start because
> >> it is looking for model,msdb, temp in the original
> >> location which no longer exists. Had this problem on
> 2000
> >> as well. Any suggestions?
> >
> >
> >.
> >
Subscribe to:
Posts (Atom)