I need to restore a SQL 6.5 database dump onto my laptop. Unfortunately I
don't have enought disk space, so work has kindly provided a USB external
hard disk. I can create the device on that disk, but what I try and restore
the database. It comes up with a 'Unable to write to server-side connection'
error message.
Any ideas ?
Cheers
MarkHi,
After creating the device , did you tried creating the database. The size
should be identical to the source database from where you received the dump
file.
Give me more information about,
1. Location of Dump file
2. Are you able to see the logical drives (newly attached external disk)
from explorer?
If you still have issues , try creating a table on the new database created.
Thanks
Hari.
MCDBA
"Flems" <Mark.Flemans@.apakgroup.com> wrote in message
news:uLYdnMXvDHA.1788@.tk2msftngp13.phx.gbl...
> I need to restore a SQL 6.5 database dump onto my laptop. Unfortunately I
> don't have enought disk space, so work has kindly provided a USB external
> hard disk. I can create the device on that disk, but what I try and
restore
> the database. It comes up with a 'Unable to write to server-side
connection'
> error message.
> Any ideas ?
> Cheers
> Mark
>
Showing posts with label unfortunately. Show all posts
Showing posts with label unfortunately. Show all posts
Monday, March 12, 2012
Wednesday, March 7, 2012
Restore nText from Transaction Log
A user of mine deleted a chunk of data from one of our databases that
was, unfortunately, not properly backed up. I have captured the
transaction log and using ApexSQL Log I am able to view all of the
delete statements. ApexSQL Log generates undo scripts for these
deletes, but there is an issue...
The deleted records contained nText fields. In the transaction log,
these are logged as hex values and thus can't be reassigned to the
nText fields. Any operation I can perform to turn the data in the
transaction log (i.e. 0x0000ad2400000000fa12000001000100) into the
original nText?
Derek wrote:
> A user of mine deleted a chunk of data from one of our databases that
> was, unfortunately, not properly backed up. I have captured the
> transaction log and using ApexSQL Log I am able to view all of the
> delete statements. ApexSQL Log generates undo scripts for these
> deletes, but there is an issue...
> The deleted records contained nText fields. In the transaction log,
> these are logged as hex values and thus can't be reassigned to the
> nText fields. Any operation I can perform to turn the data in the
> transaction log (i.e. 0x0000ad2400000000fa12000001000100) into the
> original nText?
I would check with Apex Software to see what they say. If the text
involved is less than 4,000 bytes, you can probably cast the value back
to a nvarchar. For example:
SELECT CAST(N'ABC123' as VARBINARY(100)) -- 0x410042004300310032003300
SELECT CAST(0x410042004300310032003300 as NVARCHAR(4000)) -- ABC123
David Gugick
Quest Software
www.imceda.com
www.quest.com
was, unfortunately, not properly backed up. I have captured the
transaction log and using ApexSQL Log I am able to view all of the
delete statements. ApexSQL Log generates undo scripts for these
deletes, but there is an issue...
The deleted records contained nText fields. In the transaction log,
these are logged as hex values and thus can't be reassigned to the
nText fields. Any operation I can perform to turn the data in the
transaction log (i.e. 0x0000ad2400000000fa12000001000100) into the
original nText?
Derek wrote:
> A user of mine deleted a chunk of data from one of our databases that
> was, unfortunately, not properly backed up. I have captured the
> transaction log and using ApexSQL Log I am able to view all of the
> delete statements. ApexSQL Log generates undo scripts for these
> deletes, but there is an issue...
> The deleted records contained nText fields. In the transaction log,
> these are logged as hex values and thus can't be reassigned to the
> nText fields. Any operation I can perform to turn the data in the
> transaction log (i.e. 0x0000ad2400000000fa12000001000100) into the
> original nText?
I would check with Apex Software to see what they say. If the text
involved is less than 4,000 bytes, you can probably cast the value back
to a nvarchar. For example:
SELECT CAST(N'ABC123' as VARBINARY(100)) -- 0x410042004300310032003300
SELECT CAST(0x410042004300310032003300 as NVARCHAR(4000)) -- ABC123
David Gugick
Quest Software
www.imceda.com
www.quest.com
Restore nText from Transaction Log
A user of mine deleted a chunk of data from one of our databases that
was, unfortunately, not properly backed up. I have captured the
transaction log and using ApexSQL Log I am able to view all of the
delete statements. ApexSQL Log generates undo scripts for these
deletes, but there is an issue...
The deleted records contained nText fields. In the transaction log,
these are logged as hex values and thus can't be reassigned to the
nText fields. Any operation I can perform to turn the data in the
transaction log (i.e. 0x0000ad2400000000fa12000001000100) into the
original nText?Derek wrote:
> A user of mine deleted a chunk of data from one of our databases that
> was, unfortunately, not properly backed up. I have captured the
> transaction log and using ApexSQL Log I am able to view all of the
> delete statements. ApexSQL Log generates undo scripts for these
> deletes, but there is an issue...
> The deleted records contained nText fields. In the transaction log,
> these are logged as hex values and thus can't be reassigned to the
> nText fields. Any operation I can perform to turn the data in the
> transaction log (i.e. 0x0000ad2400000000fa12000001000100) into the
> original nText?
I would check with Apex Software to see what they say. If the text
involved is less than 4,000 bytes, you can probably cast the value back
to a nvarchar. For example:
SELECT CAST(N'ABC123' as VARBINARY(100)) -- 0x410042004300310032003300
SELECT CAST(0x410042004300310032003300 as NVARCHAR(4000)) -- ABC123
David Gugick
Quest Software
www.imceda.com
www.quest.com
was, unfortunately, not properly backed up. I have captured the
transaction log and using ApexSQL Log I am able to view all of the
delete statements. ApexSQL Log generates undo scripts for these
deletes, but there is an issue...
The deleted records contained nText fields. In the transaction log,
these are logged as hex values and thus can't be reassigned to the
nText fields. Any operation I can perform to turn the data in the
transaction log (i.e. 0x0000ad2400000000fa12000001000100) into the
original nText?Derek wrote:
> A user of mine deleted a chunk of data from one of our databases that
> was, unfortunately, not properly backed up. I have captured the
> transaction log and using ApexSQL Log I am able to view all of the
> delete statements. ApexSQL Log generates undo scripts for these
> deletes, but there is an issue...
> The deleted records contained nText fields. In the transaction log,
> these are logged as hex values and thus can't be reassigned to the
> nText fields. Any operation I can perform to turn the data in the
> transaction log (i.e. 0x0000ad2400000000fa12000001000100) into the
> original nText?
I would check with Apex Software to see what they say. If the text
involved is less than 4,000 bytes, you can probably cast the value back
to a nvarchar. For example:
SELECT CAST(N'ABC123' as VARBINARY(100)) -- 0x410042004300310032003300
SELECT CAST(0x410042004300310032003300 as NVARCHAR(4000)) -- ABC123
David Gugick
Quest Software
www.imceda.com
www.quest.com
Restore nText from Transaction Log
A user of mine deleted a chunk of data from one of our databases that
was, unfortunately, not properly backed up. I have captured the
transaction log and using ApexSQL Log I am able to view all of the
delete statements. ApexSQL Log generates undo scripts for these
deletes, but there is an issue...
The deleted records contained nText fields. In the transaction log,
these are logged as hex values and thus can't be reassigned to the
nText fields. Any operation I can perform to turn the data in the
transaction log (i.e. 0x0000ad2400000000fa12000001000100) into the
original nText?Derek wrote:
> A user of mine deleted a chunk of data from one of our databases that
> was, unfortunately, not properly backed up. I have captured the
> transaction log and using ApexSQL Log I am able to view all of the
> delete statements. ApexSQL Log generates undo scripts for these
> deletes, but there is an issue...
> The deleted records contained nText fields. In the transaction log,
> these are logged as hex values and thus can't be reassigned to the
> nText fields. Any operation I can perform to turn the data in the
> transaction log (i.e. 0x0000ad2400000000fa12000001000100) into the
> original nText?
I would check with Apex Software to see what they say. If the text
involved is less than 4,000 bytes, you can probably cast the value back
to a nvarchar. For example:
SELECT CAST(N'ABC123' as VARBINARY(100)) -- 0x410042004300310032003300
SELECT CAST(0x410042004300310032003300 as NVARCHAR(4000)) -- ABC123
David Gugick
Quest Software
www.imceda.com
www.quest.com
was, unfortunately, not properly backed up. I have captured the
transaction log and using ApexSQL Log I am able to view all of the
delete statements. ApexSQL Log generates undo scripts for these
deletes, but there is an issue...
The deleted records contained nText fields. In the transaction log,
these are logged as hex values and thus can't be reassigned to the
nText fields. Any operation I can perform to turn the data in the
transaction log (i.e. 0x0000ad2400000000fa12000001000100) into the
original nText?Derek wrote:
> A user of mine deleted a chunk of data from one of our databases that
> was, unfortunately, not properly backed up. I have captured the
> transaction log and using ApexSQL Log I am able to view all of the
> delete statements. ApexSQL Log generates undo scripts for these
> deletes, but there is an issue...
> The deleted records contained nText fields. In the transaction log,
> these are logged as hex values and thus can't be reassigned to the
> nText fields. Any operation I can perform to turn the data in the
> transaction log (i.e. 0x0000ad2400000000fa12000001000100) into the
> original nText?
I would check with Apex Software to see what they say. If the text
involved is less than 4,000 bytes, you can probably cast the value back
to a nvarchar. For example:
SELECT CAST(N'ABC123' as VARBINARY(100)) -- 0x410042004300310032003300
SELECT CAST(0x410042004300310032003300 as NVARCHAR(4000)) -- ABC123
David Gugick
Quest Software
www.imceda.com
www.quest.com
Saturday, February 25, 2012
restore master without sqlserver running?
due to a snafu on the reconfiguring of a server, a raid with the
database files was reformatted. unfortunately, our backup software does
not backup the db files since they are in use at the time of backup.
now, sqlserver won't start because there is no master.mdf file. i do
have a backup of the master db. is there any way i can restore that
without sqlserver running? or will i have to reinstall sqlserver and
then restore master along with all the other db's?This is a multi-part message in MIME format.
--=_NextPart_000_0135_01C3A9CE.AE173720
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
You can use the rebuildm.exe utility to rebuild master and then restore your
backup once that is done.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"chxxx" <chxxx@.dontemailme.com> wrote in message
news:3FB39E43.BBB2A260@.dontemailme.com...
due to a snafu on the reconfiguring of a server, a raid with the
database files was reformatted. unfortunately, our backup software does
not backup the db files since they are in use at the time of backup.
now, sqlserver won't start because there is no master.mdf file. i do
have a backup of the master db. is there any way i can restore that
without sqlserver running? or will i have to reinstall sqlserver and
then restore master along with all the other db's?
--=_NextPart_000_0135_01C3A9CE.AE173720
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
You can use the rebuildm.exe utility =to rebuild master and then restore your backup once that is done.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"chxxx" =wrote in message news:3FB39E43.BBB2A260@.do=ntemailme.com...due to a snafu on the reconfiguring of a server, a raid with thedatabase =files was reformatted. unfortunately, our backup software doesnot =backup the db files since they are in use at the time of backup.now, sqlserver =won't start because there is no master.mdf file. i dohave a backup =of the master db. is there any way i can restore thatwithout =sqlserver running? or will i have to reinstall sqlserver andthen restore =master along with all the other db's?
--=_NextPart_000_0135_01C3A9CE.AE173720--|||Ch
Look in books on line for how to restore your master
database. If you have a copy of the master.mdf, you may be
able to copy it to the location it should be in (d:mssql
or similar) and start sql server without needing to do
anything else.
If you can't restore master either way. If you still have
your user database you can do a fresh install and then
attach your databases. You will need to add your user
logins to the server before you can use it.
If you can not recover the msdb database you will also
need to recreate any jobs you had.
Hope this helps
John|||chxxx wrote:
> due to a snafu on the reconfiguring of a server, a raid with the
> database files was reformatted. unfortunately, our backup software
> does not backup the db files since they are in use at the time of
> backup. now, sqlserver won't start because there is no master.mdf
> file. i do have a backup of the master db. is there any way i can
> restore that without sqlserver running? or will i have to reinstall
> sqlserver and then restore master along with all the other db's?
when you say you have a backup of the master file is it a sql backup or
a standard file backup. If latter then you should be able to restore
that to its location and restart the server. If you are saying you have
a sql backup then you will need sql started in order to restore. You
can rebuild the master (rebuildm) and once sql is started you can
restore back from your sql backup to return to the original one.
--
Br,
Mark Broadbent
mcdba , mcse+i
=============|||Mark Broadbent wrote:
> chxxx wrote:
> > due to a snafu on the reconfiguring of a server, a raid with the
> > database files was reformatted. unfortunately, our backup software
> > does not backup the db files since they are in use at the time of
> > backup. now, sqlserver won't start because there is no master.mdf
> > file. i do have a backup of the master db. is there any way i can
> > restore that without sqlserver running? or will i have to reinstall
> > sqlserver and then restore master along with all the other db's?
> when you say you have a backup of the master file is it a sql backup or
> a standard file backup. If latter then you should be able to restore
> that to its location and restart the server. If you are saying you have
> a sql backup then you will need sql started in order to restore. You
> can rebuild the master (rebuildm) and once sql is started you can
> restore back from your sql backup to return to the original one.
the only backups i have are the sql backup files (.bak). the .mdf and .ldf
files are gone due to backup software not being able to back those up.
after reading bol, looks like i'll be able to use rebuildm to get sqlserver
running again.
then i'll be able to restore master and all other db's from the .bak files
i have on disk.|||chxxx wrote:
>
> Mark Broadbent wrote:
> > chxxx wrote:
> >
> > > due to a snafu on the reconfiguring of a server, a raid with the
> > > database files was reformatted. unfortunately, our backup
> > > software does not backup the db files since they are in use at
> > > the time of backup. now, sqlserver won't start because there is
> > > no master.mdf file. i do have a backup of the master db. is
> > > there any way i can restore that without sqlserver running? or
> > > will i have to reinstall sqlserver and then restore master along
> > > with all the other db's?
> >
> > when you say you have a backup of the master file is it a sql
> > backup or a standard file backup. If latter then you should be able
> > to restore that to its location and restart the server. If you are
> > saying you have a sql backup then you will need sql started in
> > order to restore. You can rebuild the master (rebuildm) and once
> > sql is started you can restore back from your sql backup to return
> > to the original one.
> the only backups i have are the sql backup files (.bak). the .mdf
> and .ldf files are gone due to backup software not being able to back
> those up.
> after reading bol, looks like i'll be able to use rebuildm to get
> sqlserver running again.
> then i'll be able to restore master and all other db's from the .bak
> files i have on disk.
Correct :?)
--
Br,
Mark Broadbent
mcdba , mcse+i
=============
database files was reformatted. unfortunately, our backup software does
not backup the db files since they are in use at the time of backup.
now, sqlserver won't start because there is no master.mdf file. i do
have a backup of the master db. is there any way i can restore that
without sqlserver running? or will i have to reinstall sqlserver and
then restore master along with all the other db's?This is a multi-part message in MIME format.
--=_NextPart_000_0135_01C3A9CE.AE173720
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
You can use the rebuildm.exe utility to rebuild master and then restore your
backup once that is done.
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"chxxx" <chxxx@.dontemailme.com> wrote in message
news:3FB39E43.BBB2A260@.dontemailme.com...
due to a snafu on the reconfiguring of a server, a raid with the
database files was reformatted. unfortunately, our backup software does
not backup the db files since they are in use at the time of backup.
now, sqlserver won't start because there is no master.mdf file. i do
have a backup of the master db. is there any way i can restore that
without sqlserver running? or will i have to reinstall sqlserver and
then restore master along with all the other db's?
--=_NextPart_000_0135_01C3A9CE.AE173720
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
You can use the rebuildm.exe utility =to rebuild master and then restore your backup once that is done.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"chxxx"
--=_NextPart_000_0135_01C3A9CE.AE173720--|||Ch
Look in books on line for how to restore your master
database. If you have a copy of the master.mdf, you may be
able to copy it to the location it should be in (d:mssql
or similar) and start sql server without needing to do
anything else.
If you can't restore master either way. If you still have
your user database you can do a fresh install and then
attach your databases. You will need to add your user
logins to the server before you can use it.
If you can not recover the msdb database you will also
need to recreate any jobs you had.
Hope this helps
John|||chxxx wrote:
> due to a snafu on the reconfiguring of a server, a raid with the
> database files was reformatted. unfortunately, our backup software
> does not backup the db files since they are in use at the time of
> backup. now, sqlserver won't start because there is no master.mdf
> file. i do have a backup of the master db. is there any way i can
> restore that without sqlserver running? or will i have to reinstall
> sqlserver and then restore master along with all the other db's?
when you say you have a backup of the master file is it a sql backup or
a standard file backup. If latter then you should be able to restore
that to its location and restart the server. If you are saying you have
a sql backup then you will need sql started in order to restore. You
can rebuild the master (rebuildm) and once sql is started you can
restore back from your sql backup to return to the original one.
--
Br,
Mark Broadbent
mcdba , mcse+i
=============|||Mark Broadbent wrote:
> chxxx wrote:
> > due to a snafu on the reconfiguring of a server, a raid with the
> > database files was reformatted. unfortunately, our backup software
> > does not backup the db files since they are in use at the time of
> > backup. now, sqlserver won't start because there is no master.mdf
> > file. i do have a backup of the master db. is there any way i can
> > restore that without sqlserver running? or will i have to reinstall
> > sqlserver and then restore master along with all the other db's?
> when you say you have a backup of the master file is it a sql backup or
> a standard file backup. If latter then you should be able to restore
> that to its location and restart the server. If you are saying you have
> a sql backup then you will need sql started in order to restore. You
> can rebuild the master (rebuildm) and once sql is started you can
> restore back from your sql backup to return to the original one.
the only backups i have are the sql backup files (.bak). the .mdf and .ldf
files are gone due to backup software not being able to back those up.
after reading bol, looks like i'll be able to use rebuildm to get sqlserver
running again.
then i'll be able to restore master and all other db's from the .bak files
i have on disk.|||chxxx wrote:
>
> Mark Broadbent wrote:
> > chxxx wrote:
> >
> > > due to a snafu on the reconfiguring of a server, a raid with the
> > > database files was reformatted. unfortunately, our backup
> > > software does not backup the db files since they are in use at
> > > the time of backup. now, sqlserver won't start because there is
> > > no master.mdf file. i do have a backup of the master db. is
> > > there any way i can restore that without sqlserver running? or
> > > will i have to reinstall sqlserver and then restore master along
> > > with all the other db's?
> >
> > when you say you have a backup of the master file is it a sql
> > backup or a standard file backup. If latter then you should be able
> > to restore that to its location and restart the server. If you are
> > saying you have a sql backup then you will need sql started in
> > order to restore. You can rebuild the master (rebuildm) and once
> > sql is started you can restore back from your sql backup to return
> > to the original one.
> the only backups i have are the sql backup files (.bak). the .mdf
> and .ldf files are gone due to backup software not being able to back
> those up.
> after reading bol, looks like i'll be able to use rebuildm to get
> sqlserver running again.
> then i'll be able to restore master and all other db's from the .bak
> files i have on disk.
Correct :?)
--
Br,
Mark Broadbent
mcdba , mcse+i
=============
Subscribe to:
Posts (Atom)