Hi Praveen,

Good point. I'll try to write this into a vbs file (i'm actually not too competent in vb scripting, learnt recently).

Even then it'd prompt you twice with a message...

Please remove the commented lines written before the < HTML > tag.

From BOL :

A log backup taken from a possibly damaged database to capture log records that have not yet been backed up. A tail-log backup is taken after a...

you can check that from windows explorer file creation date property. However, if sql server services has been recycled after file creation, you wont get accurate date as tempdb is...

when we are restoring a database, we are essentially creating a new database and hence i tried for dbcreator role. I think this should be an optimal solution.

I gave dbcreator fixed server role to the user i created and this user was able to restore the database.

can u try that out.

This is how i connect to sql server using vb 6.0

constr = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;"

constr = constr + "Initial Catalog=master;"

constr...

You can provide that user with db_backupoperator fixed database role on all databases which that user will have the privilages to backup.

gururajkamath (11/10/2009)

---

the query provided by you is not showing database count, it can be used for table count, how we can get the database count in the sql server? is...

Instead of asking these questions, why dont you put little effort in googling for answers. Show us what effort u've put to find out answers and then we'd be glad...

I agree with Ian's suggestion to consider Database Mirroring as ur disaster recovery solution. You may also consider Log shipping (only coz of its ease of implementation and maintainance)..

you'll need to use with differential clause...

sample code:

declare @log_name as varchar(50)

set @log_name='c:\backup\test_Diff_' + convert(varchar,getdate(),112) + '.bak'

backup database test to disk=@log_name with differential

One thing to note here..

Backup files will continously be created. You'll need to delete old files manually to prevent the disk from getting full.

Thanks for the feedback. Much appreciated:-)

A similar code and a seperate job would suffice for full backups.

declare @log_name as varchar(50)

set @log_name='c:\backup\test_Full_' + convert(varchar,getdate(),112) + '.bak'

backup database test to disk=@log_name

As stated earlier, do not forget to...