Could you please explain me detail how to "reenabling the account as the logon account via EM"?

Thanks

Yes, it can run as service, because I use windows account for long time, but now suddenly this issue happens

Hi everybody

Should I back to this topic. I have some questions:

1) We can get current LSN of file created by Backup Log via topic http://msdn.microsoft.com/en-us/library/ms178536.aspx

But how to...

This topic may can help you

http://www.sqlservercentral.com/Forums/Topic737294-24-1.aspx

Best regards

Lynn Pettis (6/24/2009)

---

The other option is to create a job on the standby server and after moving the file across, use sp_start_job on the standby server to start the job...

Yes, I already copy backup data file from PRI to STB then recover

So I don't thing problem by network, may be by Server Link

Yes, I map linking by SA user, and I tested with small DB, it restored OK

Problem with big data

Let me explain more

My Primary server is "PRI", my Standby server is "STB". I put SP restoreDB in Master of STB

So from taskjob of PRI I run SP: exec...

I face to another problem:

When I run SP to restore StandbyDB from PrimaryDB via Server Linked, I have error:

Executed as user: XYZ\sqlagent. Could not relay results of procedure 'bgrestoredb' from...

Yes, I've done in Standard version.

I plan to Backup Log but not apply them immediately to Standby and I use some Windows tool to synchronize these files from Primary to...

Now I'm clear.

Thanks very much

You're right. I've done

How to get the last LSN of current DB, how to get current LSN of file created by Backup Log?

When I try "restore database test with recovery", I have this error

Server: Msg 3101, Level 16, State 2, Line 1

Exclusive access could not be obtained because the database is in...

OK, you are right.

Could you please show me the way to switch Standby DB from ReadOnly to main DB after apply LOG backup files

I try to uncheck "Read Only" option...

Dear PS

Now I'm also clear:

- No need SQL Enterprise version

- Backup FULL one or more times daily, backup LOG frequency hourly

- Quite same as Oracle Data Guard, but no...