hemadribabu (11/11/2010)

---

Hi

sql 2005

I have to take a Backup of a table from prod instance and restore the same in Reporting instance.

this process should be automated, kindly tell me...

nealhudson77 (11/11/2010)

---

The Apex tool isn't giving me much...

Ok what about this:

I restore the first backup (.bak @ 2am)

I turn on audit tracing

I restore the 4 .trn files

What would that give...

Wintel guys copied the file to dev server. They didn't tell what the issue was:ermm:

Thanks for correcting me Gail. 🙂

As Gail mentioned earlier, Transaction log is not an optional component and you cannot turn it on or...

am just hoping the trial edition gives him that feature to read from log backups.. i haven't used it yet.

was the instance restarted? if yes it may take a while to roll forward transactions which depends on certain configuration settings.

Audit trace is disabled on...

Hmmm Thanks. I dont hv access to see that. Will need help from wintel guys on this.

There are third party log reader tools available.

you may want to see this.

http://www.apexsql.com/sql_tools_log.aspx

Thanks for the reply.

I had noted the trace id which was 2.

currently only one trace is running with an id of 1 which is the default trace.

Any idea what else...

what does the following code return?

select value from sys.configurations where name='c2 audit mode'

do u have an audit trace running/3rd party auditing tool installed and running on server?

Since ur database is in simple recovery mode, i guess you must be taking full backup. This has no effect on the log file size.

In simple recovery mode, log...

Did you read the article Gail suggested?

If the log file is filling fast, you need to increase the frequency of your log backups or let it increase to a size...