Dear all,
I would like to ask if I can recover those databases from tape if I just
backup all the folders under the "C:\Program Files" ? I have export those
databases to files...
As my server's HDD is fail and I only get the DLT Tape back.
Please give me some advises!
Thanks all!if you have valid backup of c:\program files\ microsoft sql server\...\data
folder and your data files are in this folder you can attach the mdf and ldf
files to another servers.
Look for sp_attach_db in BOL
not sure what you meant with "I have export those databases to files..."
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:D8A6D646-6778-4DA1-AA50-7D50383E1B09@.microsoft.com...
> Dear all,
> I would like to ask if I can recover those databases from tape if I just
> backup all the folders under the "C:\Program Files" ? I have export those
> databases to files...
> As my server's HDD is fail and I only get the DLT Tape back.
> Please give me some advises!
> Thanks all!|||Thx for your reply!
actually, it's my typing mistake...
it should be "i haven't exported those database as a file"
"ME" wrote:
> if you have valid backup of c:\program files\ microsoft sql server\...\data
> folder and your data files are in this folder you can attach the mdf and ldf
> files to another servers.
> Look for sp_attach_db in BOL
> not sure what you meant with "I have export those databases to files..."
>
> "Kevin" <Kevin@.discussions.microsoft.com> wrote in message
> news:D8A6D646-6778-4DA1-AA50-7D50383E1B09@.microsoft.com...
> > Dear all,
> >
> > I would like to ask if I can recover those databases from tape if I just
> > backup all the folders under the "C:\Program Files" ? I have export those
> > databases to files...
> >
> > As my server's HDD is fail and I only get the DLT Tape back.
> >
> > Please give me some advises!
> >
> > Thanks all!
>
>|||so you were able to attach the mdf and ldf files?
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:FF8B6AC6-7F80-4D83-B14C-2A21235E56D8@.microsoft.com...
> Thx for your reply!
> actually, it's my typing mistake...
> it should be "i haven't exported those database as a file"
> "ME" wrote:
>> if you have valid backup of c:\program files\ microsoft sql
>> server\...\data
>> folder and your data files are in this folder you can attach the mdf and
>> ldf
>> files to another servers.
>> Look for sp_attach_db in BOL
>> not sure what you meant with "I have export those databases to files..."
>>
>> "Kevin" <Kevin@.discussions.microsoft.com> wrote in message
>> news:D8A6D646-6778-4DA1-AA50-7D50383E1B09@.microsoft.com...
>> > Dear all,
>> >
>> > I would like to ask if I can recover those databases from tape if I
>> > just
>> > backup all the folders under the "C:\Program Files" ? I have export
>> > those
>> > databases to files...
>> >
>> > As my server's HDD is fail and I only get the DLT Tape back.
>> >
>> > Please give me some advises!
>> >
>> > Thanks all!
>>
Showing posts with label program. Show all posts
Showing posts with label program. Show all posts
Wednesday, March 21, 2012
Recover the MSSQL Server 2000 from DLT Tape
Dear all,
I would like to ask if I can recover those databases from tape if I just
backup all the folders under the "C:\Program Files" ? I have export those
databases to files...
As my server's HDD is fail and I only get the DLT Tape back.
Please give me some advises!
Thanks all!if you have valid backup of c:\program files\ microsoft sql server\...\data
folder and your data files are in this folder you can attach the mdf and ldf
files to another servers.
Look for sp_attach_db in BOL
not sure what you meant with "I have export those databases to files..."
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:D8A6D646-6778-4DA1-AA50-7D50383E1B09@.microsoft.com...
> Dear all,
> I would like to ask if I can recover those databases from tape if I just
> backup all the folders under the "C:\Program Files" ? I have export those
> databases to files...
> As my server's HDD is fail and I only get the DLT Tape back.
> Please give me some advises!
> Thanks all!|||Thx for your reply!
actually, it's my typing mistake...
it should be "i haven't exported those database as a file"
"ME" wrote:
> if you have valid backup of c:\program files\ microsoft sql server\...\da
ta
> folder and your data files are in this folder you can attach the mdf and l
df
> files to another servers.
> Look for sp_attach_db in BOL
> not sure what you meant with "I have export those databases to files..."
>
> "Kevin" <Kevin@.discussions.microsoft.com> wrote in message
> news:D8A6D646-6778-4DA1-AA50-7D50383E1B09@.microsoft.com...
>
>|||so you were able to attach the mdf and ldf files?
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:FF8B6AC6-7F80-4D83-B14C-2A21235E56D8@.microsoft.com...[vbcol=seagreen]
> Thx for your reply!
> actually, it's my typing mistake...
> it should be "i haven't exported those database as a file"
> "ME" wrote:
>
I would like to ask if I can recover those databases from tape if I just
backup all the folders under the "C:\Program Files" ? I have export those
databases to files...
As my server's HDD is fail and I only get the DLT Tape back.
Please give me some advises!
Thanks all!if you have valid backup of c:\program files\ microsoft sql server\...\data
folder and your data files are in this folder you can attach the mdf and ldf
files to another servers.
Look for sp_attach_db in BOL
not sure what you meant with "I have export those databases to files..."
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:D8A6D646-6778-4DA1-AA50-7D50383E1B09@.microsoft.com...
> Dear all,
> I would like to ask if I can recover those databases from tape if I just
> backup all the folders under the "C:\Program Files" ? I have export those
> databases to files...
> As my server's HDD is fail and I only get the DLT Tape back.
> Please give me some advises!
> Thanks all!|||Thx for your reply!
actually, it's my typing mistake...
it should be "i haven't exported those database as a file"
"ME" wrote:
> if you have valid backup of c:\program files\ microsoft sql server\...\da
ta
> folder and your data files are in this folder you can attach the mdf and l
df
> files to another servers.
> Look for sp_attach_db in BOL
> not sure what you meant with "I have export those databases to files..."
>
> "Kevin" <Kevin@.discussions.microsoft.com> wrote in message
> news:D8A6D646-6778-4DA1-AA50-7D50383E1B09@.microsoft.com...
>
>|||so you were able to attach the mdf and ldf files?
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:FF8B6AC6-7F80-4D83-B14C-2A21235E56D8@.microsoft.com...[vbcol=seagreen]
> Thx for your reply!
> actually, it's my typing mistake...
> it should be "i haven't exported those database as a file"
> "ME" wrote:
>
Recover the MSSQL Server 2000 from DLT Tape
Dear all,
I would like to ask if I can recover those databases from tape if I just
backup all the folders under the "C:\Program Files" ? I have export those
databases to files...
As my server's HDD is fail and I only get the DLT Tape back.
Please give me some advises!
Thanks all!
if you have valid backup of c:\program files\ microsoft sql server\...\data
folder and your data files are in this folder you can attach the mdf and ldf
files to another servers.
Look for sp_attach_db in BOL
not sure what you meant with "I have export those databases to files..."
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:D8A6D646-6778-4DA1-AA50-7D50383E1B09@.microsoft.com...
> Dear all,
> I would like to ask if I can recover those databases from tape if I just
> backup all the folders under the "C:\Program Files" ? I have export those
> databases to files...
> As my server's HDD is fail and I only get the DLT Tape back.
> Please give me some advises!
> Thanks all!
|||Thx for your reply!
actually, it's my typing mistake...
it should be "i haven't exported those database as a file"
"ME" wrote:
> if you have valid backup of c:\program files\ microsoft sql server\...\data
> folder and your data files are in this folder you can attach the mdf and ldf
> files to another servers.
> Look for sp_attach_db in BOL
> not sure what you meant with "I have export those databases to files..."
>
> "Kevin" <Kevin@.discussions.microsoft.com> wrote in message
> news:D8A6D646-6778-4DA1-AA50-7D50383E1B09@.microsoft.com...
>
>
|||so you were able to attach the mdf and ldf files?
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:FF8B6AC6-7F80-4D83-B14C-2A21235E56D8@.microsoft.com...[vbcol=seagreen]
> Thx for your reply!
> actually, it's my typing mistake...
> it should be "i haven't exported those database as a file"
> "ME" wrote:
I would like to ask if I can recover those databases from tape if I just
backup all the folders under the "C:\Program Files" ? I have export those
databases to files...
As my server's HDD is fail and I only get the DLT Tape back.
Please give me some advises!
Thanks all!
if you have valid backup of c:\program files\ microsoft sql server\...\data
folder and your data files are in this folder you can attach the mdf and ldf
files to another servers.
Look for sp_attach_db in BOL
not sure what you meant with "I have export those databases to files..."
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:D8A6D646-6778-4DA1-AA50-7D50383E1B09@.microsoft.com...
> Dear all,
> I would like to ask if I can recover those databases from tape if I just
> backup all the folders under the "C:\Program Files" ? I have export those
> databases to files...
> As my server's HDD is fail and I only get the DLT Tape back.
> Please give me some advises!
> Thanks all!
|||Thx for your reply!
actually, it's my typing mistake...
it should be "i haven't exported those database as a file"
"ME" wrote:
> if you have valid backup of c:\program files\ microsoft sql server\...\data
> folder and your data files are in this folder you can attach the mdf and ldf
> files to another servers.
> Look for sp_attach_db in BOL
> not sure what you meant with "I have export those databases to files..."
>
> "Kevin" <Kevin@.discussions.microsoft.com> wrote in message
> news:D8A6D646-6778-4DA1-AA50-7D50383E1B09@.microsoft.com...
>
>
|||so you were able to attach the mdf and ldf files?
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:FF8B6AC6-7F80-4D83-B14C-2A21235E56D8@.microsoft.com...[vbcol=seagreen]
> Thx for your reply!
> actually, it's my typing mistake...
> it should be "i haven't exported those database as a file"
> "ME" wrote:
Monday, February 20, 2012
Recordet Problem
I'm creating a Visual Basic program linked to an SQL server DB. In one of my tables I have a field for phone number which is an nvarchar datatype that is stored in the following format (example: 617-782-6415).
I have a form where I want to view the contents of the following recordset:
SELECT d .ACCOUNT_CODE, d .DURATION, d .[DATE], d .[HOUR], d .NUMBER_DIALED, p.ACCOUNT_CODE AS Expr1, p.LAST_NAME, p.FIRST_NAME,
p.SUMMARY_GROUP, p.DIRECT_DIAL, p.TITLE, p.LOCATION, p.DIVISION, p.DEPARTMENT, p.DIRECTOR, p.OLD_CARD_NUM, p.REISSUE, p.CLASS,
p.PHONE
FROM DETAIL d INNER JOIN
PHONE_EMP_MAST p ON d .ACCOUNT_CODE = p.ACCOUNT_CODE
WHERE number_dialed = " & astring & "
The value for astring is pulled from a combobox that stores all the values for number_dialed. However when i run this program i get the error message
"syntax error converting the nvarchar value '401-781-7078' to a column of datatype int"
I dont need to convert it to a column of datatype int so I dont understand this error... can anyone help me?The only thing that can be forcing a convertion is
WHERE number_dialed = " & astring & "
What is this tryin to do?
Take one value frm teh combo box?
I assume as you have " as the string delimitter then you are trying to form the select in VB.
You would be better to create an SP and pass the parameter.
For your string here try
WHERE number_dialed = '" & astring & "'"
i.e. making astring into a string in the query.|||Yeah, I'm trying to form the select in VB because I'm more familiar with that way... I'd prefer to do it in VB if at all possible... Why is it converting it?|||WHERE number_dialed = " & astring & "
will give something like
WHERE number_dialed = 617-782-6415
it will evaluate 617-782-6415 giving a negative number then try to convert number_dialed to an integer for the compare.
you need
WHERE number_dialed = '617-782-6415'
to do a string compare
hence the quotes in my previous post.
I have a form where I want to view the contents of the following recordset:
SELECT d .ACCOUNT_CODE, d .DURATION, d .[DATE], d .[HOUR], d .NUMBER_DIALED, p.ACCOUNT_CODE AS Expr1, p.LAST_NAME, p.FIRST_NAME,
p.SUMMARY_GROUP, p.DIRECT_DIAL, p.TITLE, p.LOCATION, p.DIVISION, p.DEPARTMENT, p.DIRECTOR, p.OLD_CARD_NUM, p.REISSUE, p.CLASS,
p.PHONE
FROM DETAIL d INNER JOIN
PHONE_EMP_MAST p ON d .ACCOUNT_CODE = p.ACCOUNT_CODE
WHERE number_dialed = " & astring & "
The value for astring is pulled from a combobox that stores all the values for number_dialed. However when i run this program i get the error message
"syntax error converting the nvarchar value '401-781-7078' to a column of datatype int"
I dont need to convert it to a column of datatype int so I dont understand this error... can anyone help me?The only thing that can be forcing a convertion is
WHERE number_dialed = " & astring & "
What is this tryin to do?
Take one value frm teh combo box?
I assume as you have " as the string delimitter then you are trying to form the select in VB.
You would be better to create an SP and pass the parameter.
For your string here try
WHERE number_dialed = '" & astring & "'"
i.e. making astring into a string in the query.|||Yeah, I'm trying to form the select in VB because I'm more familiar with that way... I'd prefer to do it in VB if at all possible... Why is it converting it?|||WHERE number_dialed = " & astring & "
will give something like
WHERE number_dialed = 617-782-6415
it will evaluate 617-782-6415 giving a negative number then try to convert number_dialed to an integer for the compare.
you need
WHERE number_dialed = '617-782-6415'
to do a string compare
hence the quotes in my previous post.
Subscribe to:
Posts (Atom)