You...

Total memory refers to the amount of memory that SQL Server has reserved for itself. Target memory refers to the amount of memory SQL Server needs.

If you need to...

You should have posted the question in the corruption forum...

This link might help you.

http://www.google.co.in/search?hl=en&source=hp&q=vbscript+delete+files+older+than&aq=7&aqi=g10&aql=&oq=vbscript+delete+file&gs_rfai=

if source database is available you can

1. take a full backup and move it to target. this will give u current data.

2. take a diff backup and use it along...

Backup I/O wait stats means sql server is waiting for IO to complete for the backup process.

No idea about the other one.

DBCC memorystatus

Scroll down and look out for buffer counts Buffers

value under Committed is the amount of RAM SQL Server is using.

then log shipping is out of question.

As hardware investments are probably out of the question for now, I did think of log shipping, but just couldn't...

What about your database on source server. Is it in restoring state? you said you are restoring on a different server.

Do you also take t-log backups? and does the vb application copies the t-log backups too on the target server? Or is it acceptable for you company to lose a...

Is your database accessible right now? are you trying to restore it to some other server or same server?

mcavimal-736871 (11/10/2010)

---

one more thing please tell me i can take LOG Files BAckup Without Stop the services of SQL 2005 Server.

i All ready stop the agent and i ...

SQL Server Management Studio.

may be and may be not. I have some instances hosting more than 100 databases and it will really not be feasible to create so many backup jobs. Also, if...

actually 9 jobs were not required. 1 job could have backed up all nine databases one by one.

For other issue, it looks to me like permission issue. Pls check if...