Hi,

I need to create a copy of that database on other Server.

I tried DBCC SHRINKFILE, but it doesn't shrink the file as there is no free space available in the...

Hi,

In MOSS 2007, probably the one who configured it has enabled complete logging.

There are 2 options in MOSS 2007, one where in complete logging & second partial .

Sp probably...

If there are 2 backup files, they'll be same or of different versions.

restore the lastest database backup file, it may take time (more than 1 hour) to restore if your...

The backup can be taken from client directly, by using SSMS.

Thanks but main probelem is how will job 2 come to know that job 1 is completed, it cannot be scheduled because if job 1 take more than normal time...

When you take backup next time donot check the option of "copy the tail of transaction log and leave database in restoring mode".

check the size of Log files and shrink them either by SSMS

or by using this query

dbcc shrinkfile ( logical file name,target size)

Also make sure there are no...