z*9
1 楼
我LG现在在国内，我在美国，我的485批了，LG的485 pending，LG指纹刚过期，最近又
来信安排按指纹了，可他没有AP，不能来美国按指纹，各位大师谁能有什么良策帮忙解
决这一难题，否则他的485就作废了。
Thanks a lot!
来信安排按指纹了，可他没有AP，不能来美国按指纹，各位大师谁能有什么良策帮忙解
决这一难题，否则他的485就作废了。
Thanks a lot!
y*9
2 楼
New to SQL server ( just try to learn it as an Oracle DBA), did a test about
recovering a db, can someone tell me how to do a complete recovery in the
following case:
1. big_table reference point:
1> select max(id) from big_table;
2> go
-----------
2000000
2. Backup database testdata
3. insert several records into table big_table in the testdata database
1> select max(id) from big_table;
2> go
-----------
2000003
4. Shutdown the instance
5. delete the data file: c:\Microsoft SQL server\...\testdata.mdf
6. Startup the instance
7. Try to restore/recover database testdata
In SSMS: right-click 'testdata', 'task' the restore or backup options
are grayed out ( in one case, I can proceed)
right-click another database, choose task, then restore ...
with default options, receiving the following massage:
{{{
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'TUSNC012LKVT006'. (Microsoft.SqlServer.
SmoExtended)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The tail of the log for the database "
testdata" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup
the log if it contains work you do not want to lose. Use the WITH REPLACE or
WITH STOPAT clause of the RESTORE statement to just overwrite the contents
of the log. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
}}}
8. choose: Overwrite the existing database (WITH REPLACE)
9. Database restored, but the changes made in step 3 seems lost.
$ sqlcmd
1> use testdata
2> select max(id) from big_table;
3> go
Changed database context to 'testdata'.
-----------
2000000
(1 rows affected)
Question: how can I recover the database that includes all the changes in
step 3?
Thanks!
recovering a db, can someone tell me how to do a complete recovery in the
following case:
1. big_table reference point:
1> select max(id) from big_table;
2> go
-----------
2000000
2. Backup database testdata
3. insert several records into table big_table in the testdata database
1> select max(id) from big_table;
2> go
-----------
2000003
4. Shutdown the instance
5. delete the data file: c:\Microsoft SQL server\...\testdata.mdf
6. Startup the instance
7. Try to restore/recover database testdata
In SSMS: right-click 'testdata', 'task' the restore or backup options
are grayed out ( in one case, I can proceed)
right-click another database, choose task, then restore ...
with default options, receiving the following massage:
{{{
TITLE: Microsoft SQL Server Management Studio
------------------------------
Restore failed for Server 'TUSNC012LKVT006'. (Microsoft.SqlServer.
SmoExtended)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Restore+Server&LinkId=20476
------------------------------
ADDITIONAL INFORMATION:
System.Data.SqlClient.SqlError: The tail of the log for the database "
testdata" has not been backed up. Use BACKUP LOG WITH NORECOVERY to backup
the log if it contains work you do not want to lose. Use the WITH REPLACE or
WITH STOPAT clause of the RESTORE statement to just overwrite the contents
of the log. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.1600.22+((SQL_PreRelease).080709-1414+)&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
}}}
8. choose: Overwrite the existing database (WITH REPLACE)
9. Database restored, but the changes made in step 3 seems lost.
$ sqlcmd
1> use testdata
2> select max(id) from big_table;
3> go
Changed database context to 'testdata'.
-----------
2000000
(1 rows affected)
Question: how can I recover the database that includes all the changes in
step 3?
Thanks!
c*d
3 楼
各位好，请教一个问题。
手机不能访问数字URL(200.200.0.3) 只能访问www.google.com. 但是我想访问数字URL。
有什麽好办法？
手机不能访问数字URL(200.200.0.3) 只能访问www.google.com. 但是我想访问数字URL。
有什麽好办法？
B*g
4 楼
In 8 what did you choose for revcovery state?
about
the
【在 y****9 的大作中提到】
: New to SQL server ( just try to learn it as an Oracle DBA), did a test about
: recovering a db, can someone tell me how to do a complete recovery in the
: following case:
: 1. big_table reference point:
: 1> select max(id) from big_table;
: 2> go
: -----------
: 2000000
: 2. Backup database testdata
: 3. insert several records into table big_table in the testdata database
about
the
【在 y****9 的大作中提到】
: New to SQL server ( just try to learn it as an Oracle DBA), did a test about
: recovering a db, can someone tell me how to do a complete recovery in the
: following case:
: 1. big_table reference point:
: 1> select max(id) from big_table;
: 2> go
: -----------
: 2000000
: 2. Backup database testdata
: 3. insert several records into table big_table in the testdata database
z*r
5 楼
go to tinyurl.com to convert the ip to a url
URL。
【在 c***d 的大作中提到】
: 各位好，请教一个问题。
: 手机不能访问数字URL(200.200.0.3) 只能访问www.google.com. 但是我想访问数字URL。
: 有什麽好办法？
URL。
【在 c***d 的大作中提到】
: 各位好，请教一个问题。
: 手机不能访问数字URL(200.200.0.3) 只能访问www.google.com. 但是我想访问数字URL。
: 有什麽好办法？
y*9
6 楼
==> I did not choose, so the default is:
"Leave the database ready to use by rolling back uncommitted transactions.
Additional transaction logs cannot be restored.(RESTORE WITH RECOVERY)."
I asked the question to a fellow SQL Server DBA in my work. He said in this
case we cannot do complete recovery without do transaction log backup after
step 3 and before step 4 , I can hardly believe from Oracle perspective. So
I ask this question just want to make sure.
【在 B*****g 的大作中提到】
: In 8 what did you choose for revcovery state?
:
: about
: the
c*d
7 楼
Zher, Thank you for your reply.
我是想找到一种简单方法让手机能访问IP地址。
例如：让手机访问我自己的网站（for example, www.mycompany.com） 而在www.
mycompany.com上Redirec to IP address.
有谁知道怎麽办？
我是想找到一种简单方法让手机能访问IP地址。
例如：让手机访问我自己的网站（for example, www.mycompany.com） 而在www.
mycompany.com上Redirec to IP address.
有谁知道怎麽办？
B*g
8 楼
yes, no transaction log backup you can not recover this. Your company start
to use sql server?
this
after
So
【在 y****9 的大作中提到】
:
: ==> I did not choose, so the default is:
: "Leave the database ready to use by rolling back uncommitted transactions.
: Additional transaction logs cannot be restored.(RESTORE WITH RECOVERY)."
: I asked the question to a fellow SQL Server DBA in my work. He said in this
: case we cannot do complete recovery without do transaction log backup after
: step 3 and before step 4 , I can hardly believe from Oracle perspective. So
: I ask this question just want to make sure.
to use sql server?
this
after
So
【在 y****9 的大作中提到】
:
: ==> I did not choose, so the default is:
: "Leave the database ready to use by rolling back uncommitted transactions.
: Additional transaction logs cannot be restored.(RESTORE WITH RECOVERY)."
: I asked the question to a fellow SQL Server DBA in my work. He said in this
: case we cannot do complete recovery without do transaction log backup after
: step 3 and before step 4 , I can hardly believe from Oracle perspective. So
: I ask this question just want to make sure.
z*r
9 楼
你是哪家公司？手机上网一般通过gateway，如果gateway不支持，你就没办法了。不过
俺看不出为什么gateway不支持
【在 c***d 的大作中提到】
: Zher, Thank you for your reply.
: 我是想找到一种简单方法让手机能访问IP地址。
: 例如：让手机访问我自己的网站（for example, www.mycompany.com） 而在www.
: mycompany.com上Redirec to IP address.
: 有谁知道怎麽办？
俺看不出为什么gateway不支持
【在 c***d 的大作中提到】
: Zher, Thank you for your reply.
: 我是想找到一种简单方法让手机能访问IP地址。
: 例如：让手机访问我自己的网站（for example, www.mycompany.com） 而在www.
: mycompany.com上Redirec to IP address.
: 有谁知道怎麽办？
g*l
10 楼
必须做TRANSACTION LOG BACKUP，你没有BACKUP怎么可能恢复呢？
c*d
11 楼
谢谢斑竹Zher.
我对手机远端控制很感兴趣。很多手机不支持数字IP地址，这就是我的问题所在。
我对手机远端控制很感兴趣。很多手机不支持数字IP地址，这就是我的问题所在。
y*9
12 楼
In my case, once the instance up, it can not find the data file , but the
log file is still there. I failed to find a way to backup active transaction
log (log tail), that's why I can not do complete recovery?.-- IMO, this is
really a limitation of SQL Server as compared to Oracle, in such case, it
is perfectly doable in Oracle.
In my test I have to shutdown the instance to delete the datafile to
simulate a disk failure, In reality, if a disk just failed, can we do
complete recovery ( i.e. the info in the trascation logs that have not been
backed up should preserve after recovery), I guess it should be able to,
otherwise too bad.
If the active portion of the transaction log will be lost after disk failure
, how can we choose SQL Server as production db ?
Again, new to SQL server, maybe I fail to understand some key points.
【在 g***l 的大作中提到】
: 必须做TRANSACTION LOG BACKUP，你没有BACKUP怎么可能恢复呢？
log file is still there. I failed to find a way to backup active transaction
log (log tail), that's why I can not do complete recovery?.-- IMO, this is
really a limitation of SQL Server as compared to Oracle, in such case, it
is perfectly doable in Oracle.
In my test I have to shutdown the instance to delete the datafile to
simulate a disk failure, In reality, if a disk just failed, can we do
complete recovery ( i.e. the info in the trascation logs that have not been
backed up should preserve after recovery), I guess it should be able to,
otherwise too bad.
If the active portion of the transaction log will be lost after disk failure
, how can we choose SQL Server as production db ?
Again, new to SQL server, maybe I fail to understand some key points.
【在 g***l 的大作中提到】
: 必须做TRANSACTION LOG BACKUP，你没有BACKUP怎么可能恢复呢？
c*d
13 楼
很多手机不支持数字IP地址,不知你试过没有？
tinyurl.com的方法我是过了，不行。
欢迎各路大侠出手相救。
谢谢大家。
cwmkd
tinyurl.com的方法我是过了，不行。
欢迎各路大侠出手相救。
谢谢大家。
cwmkd
y*9
14 楼
I think I got the soluton, based on the book online:
"
If the database is offline and does not start.
Try to take a tail-log backup. Because no transactions can occur at this
time, using WITH NORECOVERY is optional. If the database is damaged, use
either WITH CONTINUE_AFTER_ERROR or WITH NO_TRUNCATE.
BACKUP LOG database_name TO [WITH { CONTINUE_AFTER_ERROR |
NO_TRUNCATE }
Important:
We recommend that you avoid using NO_TRUNCATE, except when the database is
damaged.
If the database is damaged, for example, if the database does not start, a
tail-log backup succeeds only if the log files are undamaged, the database
is in a state that supports tail-log backups, and the database does not
contain any bulk-logged changes.
"
I did the following test that proves it works:
1. after restore from a baseline full backup, we have id=200004
1> use testdata
2> select max(id) from big_table;
3> go
Changed database context to 'testdata'.
-----------
2000004
2. insert
1> insert into big_table values(2000006, 1,1, 'x','y');
2> go
(1 rows affected)
1> exit
3. take the database testdata offline
4. delete the data file: c:\Microsoft SQL server\...\testdata.mdf
5. bring the database testdata online ( In SSMS it appears offline though)
6. backup the tail-log with no truncate option
1> BACKUP LOG testdata TO LOCAL_DISK_TESTDATA WITH NO_TRUNCATE ;
2> go
Processed 4 pages for database 'testdata', file 'testdata_log' on file 16.
BACKUP LOG successfully processed 4 pages in 0.106 seconds (0.230 MB/sec).
7. Restore the db ( select the full backup same as in step 1 and the log
backup created in 6)
8. verify
1> use testdata
2> select max(id) from big_table;
3> go
Changed database context to 'testdata'.
-----------
2000006
(1 rows affected)
So the key is to be able to backup tail-log before restore. Now I have some
confidence on SQL Server :-)
"
If the database is offline and does not start.
Try to take a tail-log backup. Because no transactions can occur at this
time, using WITH NORECOVERY is optional. If the database is damaged, use
either WITH CONTINUE_AFTER_ERROR or WITH NO_TRUNCATE.
BACKUP LOG database_name TO
NO_TRUNCATE }
Important:
We recommend that you avoid using NO_TRUNCATE, except when the database is
damaged.
If the database is damaged, for example, if the database does not start, a
tail-log backup succeeds only if the log files are undamaged, the database
is in a state that supports tail-log backups, and the database does not
contain any bulk-logged changes.
"
I did the following test that proves it works:
1. after restore from a baseline full backup, we have id=200004
1> use testdata
2> select max(id) from big_table;
3> go
Changed database context to 'testdata'.
-----------
2000004
2. insert
1> insert into big_table values(2000006, 1,1, 'x','y');
2> go
(1 rows affected)
1> exit
3. take the database testdata offline
4. delete the data file: c:\Microsoft SQL server\...\testdata.mdf
5. bring the database testdata online ( In SSMS it appears offline though)
6. backup the tail-log with no truncate option
1> BACKUP LOG testdata TO LOCAL_DISK_TESTDATA WITH NO_TRUNCATE ;
2> go
Processed 4 pages for database 'testdata', file 'testdata_log' on file 16.
BACKUP LOG successfully processed 4 pages in 0.106 seconds (0.230 MB/sec).
7. Restore the db ( select the full backup same as in step 1 and the log
backup created in 6)
8. verify
1> use testdata
2> select max(id) from big_table;
3> go
Changed database context to 'testdata'.
-----------
2000006
(1 rows affected)
So the key is to be able to backup tail-log before restore. Now I have some
confidence on SQL Server :-)
z*r
15 楼
俺用的Sprint的EV-DO，用74.53.4.72访问本站没有问题。这个不应该是手机的限制，
如果有这个问题应该是gateway的问题
【在 c***d 的大作中提到】
: 很多手机不支持数字IP地址,不知你试过没有？
: tinyurl.com的方法我是过了，不行。
: 欢迎各路大侠出手相救。
: 谢谢大家。
: cwmkd
如果有这个问题应该是gateway的问题
【在 c***d 的大作中提到】
: 很多手机不支持数字IP地址,不知你试过没有？
: tinyurl.com的方法我是过了，不行。
: 欢迎各路大侠出手相救。
: 谢谢大家。
: cwmkd
g*l
16 楼
你自己不BACKUP TRANSACTION LOG，还嫌SQL SERVER没有CONFIDENCE，你的FULL
BACKUP是哪年做的还不知道，去APPLY TAIL LOG BACKUP。人家说的是有FULL+经常做
TRANSCATION LOG BACKUP，最后一点LOG没有BACKU的时候，才TAIL LOG BACKUP一下，
你从来都不做TRANSCATION LOG BACKUP，DATAFILE没了靠LOG FILE去恢复，这个比较悬。
如果真的很在意DATA COMPLETION，就应该做好LOG BACKUP，15分钟一次，甚至5分钟一次。
再不放心就要做MIRRORING或者LOG SHIPPING。
BACKUP是哪年做的还不知道，去APPLY TAIL LOG BACKUP。人家说的是有FULL+经常做
TRANSCATION LOG BACKUP，最后一点LOG没有BACKU的时候，才TAIL LOG BACKUP一下，
你从来都不做TRANSCATION LOG BACKUP，DATAFILE没了靠LOG FILE去恢复，这个比较悬。
如果真的很在意DATA COMPLETION，就应该做好LOG BACKUP，15分钟一次，甚至5分钟一次。
再不放心就要做MIRRORING或者LOG SHIPPING。
c*d
17 楼
Zher, thanks.
I tried 74.53.4.72 by my cell phone, got message "too large file".
What's your result?
I tried someone else IP, got message"too large url".
My cell phone carrier is AT&T.
What do you mean that it is gateway problem?
cwmkd
I tried 74.53.4.72 by my cell phone, got message "too large file".
What's your result?
I tried someone else IP, got message"too large url".
My cell phone carrier is AT&T.
What do you mean that it is gateway problem?
cwmkd
y*9
18 楼
you totally missed my point. My purpose is to find out how to do complete
recovery in SQL server. Without proper backup tail-log before restore/
recover, no matter how often you do transaction log backup, you can not do a
COMPLETE recovery. Isn't that true?
In Oracle, when we do complete recovery, we don't need the extra step of
backup the active log ( i.e. online redo log in Oracle).
悬。
一次。
【在 g***l 的大作中提到】
: 你自己不BACKUP TRANSACTION LOG，还嫌SQL SERVER没有CONFIDENCE，你的FULL
: BACKUP是哪年做的还不知道，去APPLY TAIL LOG BACKUP。人家说的是有FULL+经常做
: TRANSCATION LOG BACKUP，最后一点LOG没有BACKU的时候，才TAIL LOG BACKUP一下，
: 你从来都不做TRANSCATION LOG BACKUP，DATAFILE没了靠LOG FILE去恢复，这个比较悬。
: 如果真的很在意DATA COMPLETION，就应该做好LOG BACKUP，15分钟一次，甚至5分钟一次。
: 再不放心就要做MIRRORING或者LOG SHIPPING。
recovery in SQL server. Without proper backup tail-log before restore/
recover, no matter how often you do transaction log backup, you can not do a
COMPLETE recovery. Isn't that true?
In Oracle, when we do complete recovery, we don't need the extra step of
backup the active log ( i.e. online redo log in Oracle).
悬。
一次。
【在 g***l 的大作中提到】
: 你自己不BACKUP TRANSACTION LOG，还嫌SQL SERVER没有CONFIDENCE，你的FULL
: BACKUP是哪年做的还不知道，去APPLY TAIL LOG BACKUP。人家说的是有FULL+经常做
: TRANSCATION LOG BACKUP，最后一点LOG没有BACKU的时候，才TAIL LOG BACKUP一下，
: 你从来都不做TRANSCATION LOG BACKUP，DATAFILE没了靠LOG FILE去恢复，这个比较悬。
: 如果真的很在意DATA COMPLETION，就应该做好LOG BACKUP，15分钟一次，甚至5分钟一次。
: 再不放心就要做MIRRORING或者LOG SHIPPING。
z*r
19 楼
mine works fine.
the cell phone usually cannot access internet directly, instead there is a
gateway to translate and format the regular web page to the format that fits
your cell phone. of cause the gateway does more that just this.
openwave is the biggest provider for this kind of gateway.
you can ask your friends who use AT&T data services, if they have the same
issue, you may want to call the customer service to open a case
【在 c***d 的大作中提到】
: Zher, thanks.
: I tried 74.53.4.72 by my cell phone, got message "too large file".
: What's your result?
: I tried someone else IP, got message"too large url".
: My cell phone carrier is AT&T.
: What do you mean that it is gateway problem?
: cwmkd
the cell phone usually cannot access internet directly, instead there is a
gateway to translate and format the regular web page to the format that fits
your cell phone. of cause the gateway does more that just this.
openwave is the biggest provider for this kind of gateway.
you can ask your friends who use AT&T data services, if they have the same
issue, you may want to call the customer service to open a case
【在 c***d 的大作中提到】
: Zher, thanks.
: I tried 74.53.4.72 by my cell phone, got message "too large file".
: What's your result?
: I tried someone else IP, got message"too large url".
: My cell phone carrier is AT&T.
: What do you mean that it is gateway problem?
: cwmkd
g*l
20 楼
ORACLE当然牛啊，不知道有多少人用过ORACLE RESTORE了FULLBACKUP,online redo log自己就APPLY的，讲讲经验。
a
【在 y****9 的大作中提到】
: you totally missed my point. My purpose is to find out how to do complete
: recovery in SQL server. Without proper backup tail-log before restore/
: recover, no matter how often you do transaction log backup, you can not do a
: COMPLETE recovery. Isn't that true?
: In Oracle, when we do complete recovery, we don't need the extra step of
: backup the active log ( i.e. online redo log in Oracle).
:
: 悬。
: 一次。
a
【在 y****9 的大作中提到】
: you totally missed my point. My purpose is to find out how to do complete
: recovery in SQL server. Without proper backup tail-log before restore/
: recover, no matter how often you do transaction log backup, you can not do a
: COMPLETE recovery. Isn't that true?
: In Oracle, when we do complete recovery, we don't need the extra step of
: backup the active log ( i.e. online redo log in Oracle).
:
: 悬。
: 一次。
j*r
21 楼
Probably it's caused by the browser. You may need to change it,
for example, from Cingular Browser to Internet Browser.
【在 c***d 的大作中提到】
: Zher, thanks.
: I tried 74.53.4.72 by my cell phone, got message "too large file".
: What's your result?
: I tried someone else IP, got message"too large url".
: My cell phone carrier is AT&T.
: What do you mean that it is gateway problem?
: cwmkd
for example, from Cingular Browser to Internet Browser.
【在 c***d 的大作中提到】
: Zher, thanks.
: I tried 74.53.4.72 by my cell phone, got message "too large file".
: What's your result?
: I tried someone else IP, got message"too large url".
: My cell phone carrier is AT&T.
: What do you mean that it is gateway problem?
: cwmkd
k*e
22 楼
残余的 log file 也是可以 replay的，不一定要backup log
虽然SQL默认是rollback
不多说了，你懂的
虽然SQL默认是rollback
不多说了，你懂的
c*d
23 楼
Thanks for reply.
I called AT&T custom service and they told me that my cell phone (SGH-D087)
doesn't support IP address function.
If anyone have interest, you could visit my home based embedded server
throuh cell phone. My IP is 66.75.73.156. You could control some LED turn on
/turn off and read temperure(raw data). Please post result here.
Thank you.
Normally we have dynamic IP address, if you use it to control your home
device through your cell phone, it is cool, isn't it?
That's why I eager
I called AT&T custom service and they told me that my cell phone (SGH-D087)
doesn't support IP address function.
If anyone have interest, you could visit my home based embedded server
throuh cell phone. My IP is 66.75.73.156. You could control some LED turn on
/turn off and read temperure(raw data). Please post result here.
Thank you.
Normally we have dynamic IP address, if you use it to control your home
device through your cell phone, it is cool, isn't it?
That's why I eager
y*9
24 楼
@Kissbigeye -
Thank you for your comments. I do believe to solve a problem there could be
more than one solutions.I searched the book online and found something that
may support your statement
http://technet.microsoft.com/en-us/library/ms187495.aspx
The first step of performing a complete restore is described as:
{{{
Typically, recovering a database to the point of failure involves the
following basic steps:
1.Back up the active transaction log (known as the tail of the log). This
creates a tail-log backup. If the active transaction log is unavailable, all
transactions in that part of the log are lost.
Important
Under the bulk-logged recovery model, backing up any log that contains bulk-
logged operations requires access to all data files in the database. If the
data files cannot be accessed, the transaction log cannot be backed up. In
that case, you have to manually redo all changes that were made since the
most recent log backup.
}}}
In the Important section - it mentioned that "you can manully redo all
changes" in case that the transaction log cannot be backup (but available).
I would appreciate if you can give some examples or test cases or cite some
well-known sources about the steps to manually apply the changes in the log.
Thanks,
Denis
【在 k********e 的大作中提到】
: 残余的 log file 也是可以 replay的，不一定要backup log
: 虽然SQL默认是rollback
: 不多说了，你懂的
Thank you for your comments. I do believe to solve a problem there could be
more than one solutions.I searched the book online and found something that
may support your statement
http://technet.microsoft.com/en-us/library/ms187495.aspx
The first step of performing a complete restore is described as:
{{{
Typically, recovering a database to the point of failure involves the
following basic steps:
1.Back up the active transaction log (known as the tail of the log). This
creates a tail-log backup. If the active transaction log is unavailable, all
transactions in that part of the log are lost.
Important
Under the bulk-logged recovery model, backing up any log that contains bulk-
logged operations requires access to all data files in the database. If the
data files cannot be accessed, the transaction log cannot be backed up. In
that case, you have to manually redo all changes that were made since the
most recent log backup.
}}}
In the Important section - it mentioned that "you can manully redo all
changes" in case that the transaction log cannot be backup (but available).
I would appreciate if you can give some examples or test cases or cite some
well-known sources about the steps to manually apply the changes in the log.
Thanks,
Denis
【在 k********e 的大作中提到】
: 残余的 log file 也是可以 replay的，不一定要backup log
: 虽然SQL默认是rollback
: 不多说了，你懂的
m*t
25 楼
in older world, the cells were using HDML/WDP/WCP/Over non-IP bearers to
access internet through a WAP gateway. But a destination URL you input
should be able to contain IP, it is more an issue of the browser.
actually, you can try to go to the landing page when you launch the wap
browser, then see if you have an option to create a bookmark or add URL from
there
)
on
【在 c***d 的大作中提到】
: Thanks for reply.
: I called AT&T custom service and they told me that my cell phone (SGH-D087)
: doesn't support IP address function.
: If anyone have interest, you could visit my home based embedded server
: throuh cell phone. My IP is 66.75.73.156. You could control some LED turn on
: /turn off and read temperure(raw data). Please post result here.
: Thank you.
: Normally we have dynamic IP address, if you use it to control your home
: device through your cell phone, it is cool, isn't it?
: That's why I eager
access internet through a WAP gateway. But a destination URL you input
should be able to contain IP, it is more an issue of the browser.
actually, you can try to go to the landing page when you launch the wap
browser, then see if you have an option to create a bookmark or add URL from
there
)
on
【在 c***d 的大作中提到】
: Thanks for reply.
: I called AT&T custom service and they told me that my cell phone (SGH-D087)
: doesn't support IP address function.
: If anyone have interest, you could visit my home based embedded server
: throuh cell phone. My IP is 66.75.73.156. You could control some LED turn on
: /turn off and read temperure(raw data). Please post result here.
: Thank you.
: Normally we have dynamic IP address, if you use it to control your home
: device through your cell phone, it is cool, isn't it?
: That's why I eager
B*g
26 楼
nod。Kissbigeye 现在应该是有经验的了，下个月开个讲座吧。
be
that
【在 y****9 的大作中提到】
: @Kissbigeye -
: Thank you for your comments. I do believe to solve a problem there could be
: more than one solutions.I searched the book online and found something that
: may support your statement
: http://technet.microsoft.com/en-us/library/ms187495.aspx
: The first step of performing a complete restore is described as:
: {{{
: Typically, recovering a database to the point of failure involves the
: following basic steps:
: 1.Back up the active transaction log (known as the tail of the log). This
be
that
【在 y****9 的大作中提到】
: @Kissbigeye -
: Thank you for your comments. I do believe to solve a problem there could be
: more than one solutions.I searched the book online and found something that
: may support your statement
: http://technet.microsoft.com/en-us/library/ms187495.aspx
: The first step of performing a complete restore is described as:
: {{{
: Typically, recovering a database to the point of failure involves the
: following basic steps:
: 1.Back up the active transaction log (known as the tail of the log). This
c*d
27 楼
Thank you, Mast.
I don't understand you solution. Could you explain more detail?
I don't understand you solution. Could you explain more detail?
m*t
28 楼
当你打开手机上浏览器，通常是自动连接到carrier 提供的一个WAP网页上,promote 各
种服务或billing 相关的功能，你在那些link 里找有没有象 add bookmark, 或者 "
goto website" 这样相关的link去Input URL, 我不sure 你是不是已经这样在用。。手
头没有ATT的phone, 只是个建议
【在 c***d 的大作中提到】
: Thank you, Mast.
: I don't understand you solution. Could you explain more detail?
j*r
29 楼
Works for me. I can see the web page, with errors.
AT&T blackberry.
)
on
【在 c***d 的大作中提到】
: Thanks for reply.
: I called AT&T custom service and they told me that my cell phone (SGH-D087)
: doesn't support IP address function.
: If anyone have interest, you could visit my home based embedded server
: throuh cell phone. My IP is 66.75.73.156. You could control some LED turn on
: /turn off and read temperure(raw data). Please post result here.
: Thank you.
: Normally we have dynamic IP address, if you use it to control your home
: device through your cell phone, it is cool, isn't it?
: That's why I eager
AT&T blackberry.
)
on
【在 c***d 的大作中提到】
: Thanks for reply.
: I called AT&T custom service and they told me that my cell phone (SGH-D087)
: doesn't support IP address function.
: If anyone have interest, you could visit my home based embedded server
: throuh cell phone. My IP is 66.75.73.156. You could control some LED turn on
: /turn off and read temperure(raw data). Please post result here.
: Thank you.
: Normally we have dynamic IP address, if you use it to control your home
: device through your cell phone, it is cool, isn't it?
: That's why I eager
c*d
30 楼
谢谢大家回帖。
我今天test了220.232.208.35(www.embed-sys.net)在我的手机上，部分成功。
看来问题不简单。
jaguar (haha），请问你能toggle LED吗？你能看到什麽？请你讲一讲好吗？
谢谢。
我今天test了220.232.208.35(www.embed-sys.net)在我的手机上，部分成功。
看来问题不简单。
jaguar (haha），请问你能toggle LED吗？你能看到什麽？请你讲一讲好吗？
谢谢。
相关阅读
[合集] Cisco怎么想的？现在这么多种类IOSDLink WBR-1310B wireless 路由器的的奇怪问题http://www.youtube.com/watch?v=GhgBQo6d9G8&feature=relatedinter-as multicast and inter-as mVPN寻找在美国的视频中继服务对回国能干什么极其困惑华为在硅谷的分部很厉害啊 (转载)HSUPA是layer 1的技术么?用邻居的无线信号,有时很弱,有什么办法可以加强吗?Who has the headhunter info for Network/Telecom. job怎么建立一个企业电话系统？有人研究过"Distributed Control Plane for 4D Architecture" 吗？家用千兆网求优化请教如何安装Wireless-G Broadband Router请教高手:看这是不是黑客双网卡的机器能限制某个网卡的流量么？Anecdotal: several CCVP openings请推荐wireless routerA question for ASP.Net, Many Thanks in advance!一个load balancer的问题