Hi,
I have created a database in server SRV1 with user 'aaa' as database owner
Know if some body detach this database from SRV1 and attach them on other
server same SRV2 with defrent sa and defrent users 'SA' user in SRV2 has ful
l
access to may database
How can restric my database for other server and other sa youser ther ?
Tanks .
Daryoush AjamiHi,
First of all restirct the access to your SQL Server. In this case no one can
detach the database and attach in SRV2.
FYI, If he have detach database access in sql server and copy the files from
operating system then he will be able to
attach the database in his server and view all tables and objects.
Thanks
hari
SQL Server MVP
"Ajami" <Ajami@.discussions.microsoft.com> wrote in message
news:34C340B7-2451-4E9C-8227-EA0AA0DF7573@.microsoft.com...
> Hi,
> I have created a database in server SRV1 with user 'aaa' as database owner
> Know if some body detach this database from SRV1 and attach them on other
> server same SRV2 with defrent sa and defrent users 'SA' user in SRV2 has
> full
> access to may database
> How can restric my database for other server and other sa youser ther ?
> Tanks .
> --
> Daryoush Ajami
Showing posts with label attach. Show all posts
Showing posts with label attach. Show all posts
Monday, March 19, 2012
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.
> >
> >
> >
database recovery testing - procedure
how frequent you guy verify database backup from tape ?
What is the procedure? do you restore from tape and attach to database
Cheers,
Hi
Have not played long time with tapes, but you can simple restore the
database to verify a file, very good practice.
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:78EAC7A2-D57F-4894-AE12-E1951E27CE76@.microsoft.com...
> how frequent you guy verify database backup from tape ?
> What is the procedure? do you restore from tape and attach to database
> Cheers,
|||soonyu,
As Uri says, restore is the best (really the only) way to test if a backup
is good. You can restore the backup to another database name, so the
restore will not overwrite your working database.
RESTORE DATABASE TestRestoreDB FROM TAPE ...
RLF
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:78EAC7A2-D57F-4894-AE12-E1951E27CE76@.microsoft.com...
> how frequent you guy verify database backup from tape ?
> What is the procedure? do you restore from tape and attach to database
> Cheers,
|||how frequent you do restoration testing per year
and what do you document in your document ?
Cheers,
soonyu
"Russell Fields" wrote:
> soonyu,
> As Uri says, restore is the best (really the only) way to test if a backup
> is good. You can restore the backup to another database name, so the
> restore will not overwrite your working database.
> RESTORE DATABASE TestRestoreDB FROM TAPE ...
> RLF
> "soonyu" <soonyu@.discussions.microsoft.com> wrote in message
> news:78EAC7A2-D57F-4894-AE12-E1951E27CE76@.microsoft.com...
>
>
|||soonyu,
I do restores all the time as a part of the regular work, to make test
copies of the database, etc. so my backups are tested frequently because of
that. Of course, you should monitor the backup jobs daily to ensure that
they are running successfully.
I have heard it recommended (and think it is a good idea) to restore some
databases every week. Rotate through your databases and servers from week
to week.
As far as documentation, a spreadsheet is fine to tick off the last test and
success or failure. (It only gets interesting when there is a failure, of
course.) I use a workflow system to track problems and resolutions.
RLF
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:46C15702-8FEA-4221-9778-48634D3F1769@.microsoft.com...[vbcol=seagreen]
> how frequent you do restoration testing per year
> and what do you document in your document ?
> Cheers,
> soonyu
> "Russell Fields" wrote:
What is the procedure? do you restore from tape and attach to database
Cheers,
Hi
Have not played long time with tapes, but you can simple restore the
database to verify a file, very good practice.
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:78EAC7A2-D57F-4894-AE12-E1951E27CE76@.microsoft.com...
> how frequent you guy verify database backup from tape ?
> What is the procedure? do you restore from tape and attach to database
> Cheers,
|||soonyu,
As Uri says, restore is the best (really the only) way to test if a backup
is good. You can restore the backup to another database name, so the
restore will not overwrite your working database.
RESTORE DATABASE TestRestoreDB FROM TAPE ...
RLF
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:78EAC7A2-D57F-4894-AE12-E1951E27CE76@.microsoft.com...
> how frequent you guy verify database backup from tape ?
> What is the procedure? do you restore from tape and attach to database
> Cheers,
|||how frequent you do restoration testing per year
and what do you document in your document ?
Cheers,
soonyu
"Russell Fields" wrote:
> soonyu,
> As Uri says, restore is the best (really the only) way to test if a backup
> is good. You can restore the backup to another database name, so the
> restore will not overwrite your working database.
> RESTORE DATABASE TestRestoreDB FROM TAPE ...
> RLF
> "soonyu" <soonyu@.discussions.microsoft.com> wrote in message
> news:78EAC7A2-D57F-4894-AE12-E1951E27CE76@.microsoft.com...
>
>
|||soonyu,
I do restores all the time as a part of the regular work, to make test
copies of the database, etc. so my backups are tested frequently because of
that. Of course, you should monitor the backup jobs daily to ensure that
they are running successfully.
I have heard it recommended (and think it is a good idea) to restore some
databases every week. Rotate through your databases and servers from week
to week.
As far as documentation, a spreadsheet is fine to tick off the last test and
success or failure. (It only gets interesting when there is a failure, of
course.) I use a workflow system to track problems and resolutions.
RLF
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:46C15702-8FEA-4221-9778-48634D3F1769@.microsoft.com...[vbcol=seagreen]
> how frequent you do restoration testing per year
> and what do you document in your document ?
> Cheers,
> soonyu
> "Russell Fields" wrote:
Friday, February 24, 2012
database recovery testing - procedure
how frequent you guy verify database backup from tape ?
What is the procedure? do you restore from tape and attach to database
Cheers,Hi
Have not played long time with tapes, but you can simple restore the
database to verify a file, very good practice.
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:78EAC7A2-D57F-4894-AE12-E1951E27CE76@.microsoft.com...
> how frequent you guy verify database backup from tape ?
> What is the procedure? do you restore from tape and attach to database
> Cheers,|||soonyu,
As Uri says, restore is the best (really the only) way to test if a backup
is good. You can restore the backup to another database name, so the
restore will not overwrite your working database.
RESTORE DATABASE TestRestoreDB FROM TAPE ...
RLF
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:78EAC7A2-D57F-4894-AE12-E1951E27CE76@.microsoft.com...
> how frequent you guy verify database backup from tape ?
> What is the procedure? do you restore from tape and attach to database
> Cheers,|||how frequent you do restoration testing per year
and what do you document in your document ?
Cheers,
soonyu
"Russell Fields" wrote:
> soonyu,
> As Uri says, restore is the best (really the only) way to test if a backup
> is good. You can restore the backup to another database name, so the
> restore will not overwrite your working database.
> RESTORE DATABASE TestRestoreDB FROM TAPE ...
> RLF
> "soonyu" <soonyu@.discussions.microsoft.com> wrote in message
> news:78EAC7A2-D57F-4894-AE12-E1951E27CE76@.microsoft.com...
> > how frequent you guy verify database backup from tape ?
> > What is the procedure? do you restore from tape and attach to database
> >
> > Cheers,
>
>|||soonyu,
I do restores all the time as a part of the regular work, to make test
copies of the database, etc. so my backups are tested frequently because of
that. Of course, you should monitor the backup jobs daily to ensure that
they are running successfully.
I have heard it recommended (and think it is a good idea) to restore some
databases every week. Rotate through your databases and servers from week
to week.
As far as documentation, a spreadsheet is fine to tick off the last test and
success or failure. (It only gets interesting when there is a failure, of
course.) I use a workflow system to track problems and resolutions.
RLF
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:46C15702-8FEA-4221-9778-48634D3F1769@.microsoft.com...
> how frequent you do restoration testing per year
> and what do you document in your document ?
> Cheers,
> soonyu
> "Russell Fields" wrote:
>> soonyu,
>> As Uri says, restore is the best (really the only) way to test if a
>> backup
>> is good. You can restore the backup to another database name, so the
>> restore will not overwrite your working database.
>> RESTORE DATABASE TestRestoreDB FROM TAPE ...
>> RLF
>> "soonyu" <soonyu@.discussions.microsoft.com> wrote in message
>> news:78EAC7A2-D57F-4894-AE12-E1951E27CE76@.microsoft.com...
>> > how frequent you guy verify database backup from tape ?
>> > What is the procedure? do you restore from tape and attach to database
>> >
>> > Cheers,
>>
What is the procedure? do you restore from tape and attach to database
Cheers,Hi
Have not played long time with tapes, but you can simple restore the
database to verify a file, very good practice.
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:78EAC7A2-D57F-4894-AE12-E1951E27CE76@.microsoft.com...
> how frequent you guy verify database backup from tape ?
> What is the procedure? do you restore from tape and attach to database
> Cheers,|||soonyu,
As Uri says, restore is the best (really the only) way to test if a backup
is good. You can restore the backup to another database name, so the
restore will not overwrite your working database.
RESTORE DATABASE TestRestoreDB FROM TAPE ...
RLF
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:78EAC7A2-D57F-4894-AE12-E1951E27CE76@.microsoft.com...
> how frequent you guy verify database backup from tape ?
> What is the procedure? do you restore from tape and attach to database
> Cheers,|||how frequent you do restoration testing per year
and what do you document in your document ?
Cheers,
soonyu
"Russell Fields" wrote:
> soonyu,
> As Uri says, restore is the best (really the only) way to test if a backup
> is good. You can restore the backup to another database name, so the
> restore will not overwrite your working database.
> RESTORE DATABASE TestRestoreDB FROM TAPE ...
> RLF
> "soonyu" <soonyu@.discussions.microsoft.com> wrote in message
> news:78EAC7A2-D57F-4894-AE12-E1951E27CE76@.microsoft.com...
> > how frequent you guy verify database backup from tape ?
> > What is the procedure? do you restore from tape and attach to database
> >
> > Cheers,
>
>|||soonyu,
I do restores all the time as a part of the regular work, to make test
copies of the database, etc. so my backups are tested frequently because of
that. Of course, you should monitor the backup jobs daily to ensure that
they are running successfully.
I have heard it recommended (and think it is a good idea) to restore some
databases every week. Rotate through your databases and servers from week
to week.
As far as documentation, a spreadsheet is fine to tick off the last test and
success or failure. (It only gets interesting when there is a failure, of
course.) I use a workflow system to track problems and resolutions.
RLF
"soonyu" <soonyu@.discussions.microsoft.com> wrote in message
news:46C15702-8FEA-4221-9778-48634D3F1769@.microsoft.com...
> how frequent you do restoration testing per year
> and what do you document in your document ?
> Cheers,
> soonyu
> "Russell Fields" wrote:
>> soonyu,
>> As Uri says, restore is the best (really the only) way to test if a
>> backup
>> is good. You can restore the backup to another database name, so the
>> restore will not overwrite your working database.
>> RESTORE DATABASE TestRestoreDB FROM TAPE ...
>> RLF
>> "soonyu" <soonyu@.discussions.microsoft.com> wrote in message
>> news:78EAC7A2-D57F-4894-AE12-E1951E27CE76@.microsoft.com...
>> > how frequent you guy verify database backup from tape ?
>> > What is the procedure? do you restore from tape and attach to database
>> >
>> > Cheers,
>>
Database Recovery
Can not attach database,
Error message;
The file you've specified is not a valid SQL Server database file.
My costumer HDD some files Deleted mybe elektric prblem -Elektric
go,com,go,come- then windows not opened.
insert corrupt hdd Another computer, then recovering (recover my files
software)
Recover mdf and ldf files. but I can not not attach mdf. file,
I am recovery .mdf file http://www.officerecovery.com/mssql/ some table ok.
but my importand table is not ok.
if I can recover another recovery software , my database correct recover or
same.?
I am using RecoverMyFiles.
Pleace help me.
Thanks.inter
Do you have a last full backup of the database?
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>|||As I indicated in my response to your earlier posting (10/27) about the same
issue:
That doesn't sound very good, and since you do NOT have a backup of the
database, it does it sound very hopeful to recover the 'lost' data.
You may wish to contact PSS and open a ticket. They 'may' be able to help
you.
See: http://support.microsoft.com/defaul...S;offerprophone
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>|||Next time if you don't have UPS backup , Enable Torn Page Detection.
Thanks
Ajay
Arnie Rowland wrote:[vbcol=seagreen]
> As I indicated in my response to your earlier posting (10/27) about the sa
me
> issue:
> That doesn't sound very good, and since you do NOT have a backup of the
> database, it does it sound very hopeful to recover the 'lost' data.
> You may wish to contact PSS and open a ticket. They 'may' be able to help
> you.
> See: http://support.microsoft.com/defaul...S;offerprophone
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to th
e
> top yourself.
> - H. Norman Schwarzkopf
>
> "inter" <halit-goktas.net> wrote in message
> news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...|||Hi,
If your data is critical please contact Microsoft PSS as Arnie suggested...
Thanks
Hari
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>
Error message;
The file you've specified is not a valid SQL Server database file.
My costumer HDD some files Deleted mybe elektric prblem -Elektric
go,com,go,come- then windows not opened.
insert corrupt hdd Another computer, then recovering (recover my files
software)
Recover mdf and ldf files. but I can not not attach mdf. file,
I am recovery .mdf file http://www.officerecovery.com/mssql/ some table ok.
but my importand table is not ok.
if I can recover another recovery software , my database correct recover or
same.?
I am using RecoverMyFiles.
Pleace help me.
Thanks.inter
Do you have a last full backup of the database?
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>|||As I indicated in my response to your earlier posting (10/27) about the same
issue:
That doesn't sound very good, and since you do NOT have a backup of the
database, it does it sound very hopeful to recover the 'lost' data.
You may wish to contact PSS and open a ticket. They 'may' be able to help
you.
See: http://support.microsoft.com/defaul...S;offerprophone
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>|||Next time if you don't have UPS backup , Enable Torn Page Detection.
Thanks
Ajay
Arnie Rowland wrote:[vbcol=seagreen]
> As I indicated in my response to your earlier posting (10/27) about the sa
me
> issue:
> That doesn't sound very good, and since you do NOT have a backup of the
> database, it does it sound very hopeful to recover the 'lost' data.
> You may wish to contact PSS and open a ticket. They 'may' be able to help
> you.
> See: http://support.microsoft.com/defaul...S;offerprophone
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to th
e
> top yourself.
> - H. Norman Schwarzkopf
>
> "inter" <halit-goktas.net> wrote in message
> news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...|||Hi,
If your data is critical please contact Microsoft PSS as Arnie suggested...
Thanks
Hari
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>
Database Recovery
Can not attach database,
Error message;
The file you've specified is not a valid SQL Server database file.
My costumer HDD some files Deleted mybe elektric prblem -Elektric
go,com,go,come- then windows not opened.
insert corrupt hdd Another computer, then recovering (recover my files
software)
Recover mdf and ldf files. but I can not not attach mdf. file,
I am recovery .mdf file http://www.officerecovery.com/mssql/ some table ok.
but my importand table is not ok.
if I can recover another recovery software , my database correct recover or
same.?
I am using RecoverMyFiles.
Pleace help me.
Thanks.inter
Do you have a last full backup of the database?
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>|||As I indicated in my response to your earlier posting (10/27) about the same
issue:
That doesn't sound very good, and since you do NOT have a backup of the
database, it does it sound very hopeful to recover the 'lost' data.
You may wish to contact PSS and open a ticket. They 'may' be able to help
you.
See: http://support.microsoft.com/default.aspx?scid=fh;EN-US;offerprophone
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>|||Next time if you don't have UPS backup , Enable Torn Page Detection.
Thanks
Ajay
Arnie Rowland wrote:
> As I indicated in my response to your earlier posting (10/27) about the same
> issue:
> That doesn't sound very good, and since you do NOT have a backup of the
> database, it does it sound very hopeful to recover the 'lost' data.
> You may wish to contact PSS and open a ticket. They 'may' be able to help
> you.
> See: http://support.microsoft.com/default.aspx?scid=fh;EN-US;offerprophone
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "inter" <halit-goktas.net> wrote in message
> news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> >
> > Can not attach database,
> > Error message;
> > The file you've specified is not a valid SQL Server database file.
> >
> >
> > My costumer HDD some files Deleted mybe elektric prblem -Elektric
> > go,com,go,come- then windows not opened.
> > insert corrupt hdd Another computer, then recovering (recover my files
> > software)
> > Recover mdf and ldf files. but I can not not attach mdf. file,
> >
> >
> > I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> > ok.
> > but my importand table is not ok.
> >
> > if I can recover another recovery software , my database correct recover
> > or
> > same.?
> > I am using RecoverMyFiles.
> >
> > Pleace help me.
> >
> > Thanks.
> >
> >|||Hi,
If your data is critical please contact Microsoft PSS as Arnie suggested...
Thanks
Hari
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>
Error message;
The file you've specified is not a valid SQL Server database file.
My costumer HDD some files Deleted mybe elektric prblem -Elektric
go,com,go,come- then windows not opened.
insert corrupt hdd Another computer, then recovering (recover my files
software)
Recover mdf and ldf files. but I can not not attach mdf. file,
I am recovery .mdf file http://www.officerecovery.com/mssql/ some table ok.
but my importand table is not ok.
if I can recover another recovery software , my database correct recover or
same.?
I am using RecoverMyFiles.
Pleace help me.
Thanks.inter
Do you have a last full backup of the database?
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>|||As I indicated in my response to your earlier posting (10/27) about the same
issue:
That doesn't sound very good, and since you do NOT have a backup of the
database, it does it sound very hopeful to recover the 'lost' data.
You may wish to contact PSS and open a ticket. They 'may' be able to help
you.
See: http://support.microsoft.com/default.aspx?scid=fh;EN-US;offerprophone
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>|||Next time if you don't have UPS backup , Enable Torn Page Detection.
Thanks
Ajay
Arnie Rowland wrote:
> As I indicated in my response to your earlier posting (10/27) about the same
> issue:
> That doesn't sound very good, and since you do NOT have a backup of the
> database, it does it sound very hopeful to recover the 'lost' data.
> You may wish to contact PSS and open a ticket. They 'may' be able to help
> you.
> See: http://support.microsoft.com/default.aspx?scid=fh;EN-US;offerprophone
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "inter" <halit-goktas.net> wrote in message
> news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> >
> > Can not attach database,
> > Error message;
> > The file you've specified is not a valid SQL Server database file.
> >
> >
> > My costumer HDD some files Deleted mybe elektric prblem -Elektric
> > go,com,go,come- then windows not opened.
> > insert corrupt hdd Another computer, then recovering (recover my files
> > software)
> > Recover mdf and ldf files. but I can not not attach mdf. file,
> >
> >
> > I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> > ok.
> > but my importand table is not ok.
> >
> > if I can recover another recovery software , my database correct recover
> > or
> > same.?
> > I am using RecoverMyFiles.
> >
> > Pleace help me.
> >
> > Thanks.
> >
> >|||Hi,
If your data is critical please contact Microsoft PSS as Arnie suggested...
Thanks
Hari
"inter" <halit-goktas.net> wrote in message
news:uYt$ae%23%23GHA.1220@.TK2MSFTNGP04.phx.gbl...
> Can not attach database,
> Error message;
> The file you've specified is not a valid SQL Server database file.
>
> My costumer HDD some files Deleted mybe elektric prblem -Elektric
> go,com,go,come- then windows not opened.
> insert corrupt hdd Another computer, then recovering (recover my files
> software)
> Recover mdf and ldf files. but I can not not attach mdf. file,
>
> I am recovery .mdf file http://www.officerecovery.com/mssql/ some table
> ok.
> but my importand table is not ok.
> if I can recover another recovery software , my database correct recover
> or
> same.?
> I am using RecoverMyFiles.
> Pleace help me.
> Thanks.
>
Subscribe to:
Posts (Atom)