Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: Reduce size of mdf file.

    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...

  • RE: TempDB log growth

    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...

  • RE: restoring database

    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...

  • RE: backup and restore

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

  • RE: Sql Server agent job

    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...

  • RE: DB restore

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

  • RE: Database Unavailable !! - What to do ?

    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...

Viewing 7 posts - 1 through 7 (of 7 total)