Re: i am afraid backup log with no_truncate is useless . ... Also, if the whole SQL Server goes down, then you can still get up to minute recovery....Backup log with no truncate behaves correctly at sql server 2000, in as much as you can back up the lock even ... when the mdf is unavailable. ... (microsoft.public.sqlserver.server)
Re: What is LOP_SHRINK_NOOP ... In the old days, the system has no nightly backup, neither the mdf nor the ldf. ... Also it's posisble the DBCC SHRINK is doing this. ... (comp.databases.ms-sqlserver)
Re: If I want to restore a backup on a different computer? ... Backup the database copy the .BAK files to destination... Copy the MDF and LDF to a new location and then execute sp_attach_db ...Backup the datbase using BACKUP DATABASE comand in source server ... (microsoft.public.sqlserver.tools)
Re: newbie backup question ... but the mdf is 1.5GB and the .ldf is ... Would it be better to switch it back to FULL recovery, ... doing a FULL backup, backup the transaction log, then ... the FULL and transaction log backup is no longer ... (microsoft.public.sqlserver.setup)
Re: What is LOP_SHRINK_NOOP ... I backup the .mdf to a .bak file on the hard disk and replace the old one each day. ... You want to back up the Database using native commands, not necessarily backing up the MDF and LDF files separately. ... using the transaction log backups.... I highly recommend you google some on how to do transaction log backups and how they help you. ... (comp.databases.ms-sqlserver)
