synchronizing is one way only..

restore the tail log backup with

"WITH RECOVERY " optiona

instead of WITH NO RECOVERY

noooooooo

we will have maintenance plans for full backup and transaction log backup. For every backup there will be a new file.

we will keep last 3 days full backups in the...

We follow the below strategy

Daily Full Backup

and Every 2 hrs Transaction Log Backup

so the data loss in case of failure will be last 2 hrs data..

so how do you want...

I have a situation where in I have syncronize the secondary server with the primary server having 20GB database, and both are in distinct locations physically

(Log shipping and Transactional replication...

Anybody has any idea of my requirement?..

Thank you in advance

Hi yonision

I have a question before I try your tool, Wil your application be able to sync/compare the databases of >20GB and 2 remotely separated database servers.???:w00t:

Thanx all of you.. for your valuable replies..:-)

why can't u use GRANT/REVOKE ...???

Shekhar..:)

Hi vidya

here is the complte script your looking for

'Set the pattern you are looking for

strPatternMatch = "wordtofind"

Set objRegEx = CreateObject("VBScript.RegExp")

objRegEx.Pattern = strPatternMatch

Set objFSO = CreateObject("Scripting.FileSystemObject")

'Set Folder = objFSO.GetFolder(strFolderToPatternMatch)

'For Each...

The below might help you buddy.. 🙂

http://msdn.microsoft.com/en-us/library/ms187445.aspx

Shekhar.

Here is an adittion to the suggestions..

http://msdn.microsoft.com/en-us/library/ms403323(SQL.90).aspx

Shekhar.. 🙂

you can use osql utility for running your script as a batch..

Shekhar..:)

ya.. using nolock hint and suitable indexes will do for you..

you have to keep in mind that how frequently you run those reports, meaning on daily basis/hourly basis/on demand.

and how...

Can you please tell me as what settings I have to change in the Surface Area Configuration manager..??.. 🙁