K. Brian Kelley (6/7/2008)

---

In SQL Server 2000, it is strongly recommended you use Enterprise Manager. So, yes, that's the correct way to do so. The reason is that Enterprise Manager...

Please check this?

GO

/****** Object:  Table [dbo].[CaseNum]   SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[CaseNum](

 [casenum] [bigint] NOT NULL,

 [warrRegNum] [varchar](9) NOT NULL,

 [LName] [varchar](50) NOT NULL,

 [FName] [varchar](50) NOT NULL,

 [Address1] [varchar](50) NOT...

Any help please! Still not able to back up logs with maintenance wizard.

I ran

select * from syscolumns where iscomputed = 1

zero record found

I ran sp_help casenum and I...

I am talking about truncating logs after log backup. But for me I cannot use wizard for log backup.

Log should truncate after full backup,right? or do you have to...

I am almost sure that we dont have views. One more thing same database on different server worked fine with all maintenance in place. I restored that database from 32bit...

how can I make my log backup work using Wizard and not script and where is the option for log cleanup in wizard?

No I dont have any computed columns.

This use to work fine on other server. only thing I did was resotred database on new server with sp2 and it's a 64bit version of sql.

recovery model is set to full.

when I select databases for log back up from maintenance plan wizard and click ok and than when I go back to and check the...

How big is it?

5Gb

What is your tolerance for data loss (e.g. 1 day, 1 hour, 15 minutes)?

1Day

Where are you currently dumping your backups to (same disk/c:?, seperate disk, tape)?

Disk

I found...

I am confused with what you told in previous post.

where do I create trigger? in master database? it will fire where any new database is created,right?

Thanks for you input Lowry.

URL not working?http://www.sql-server-performance.com/ss_creating_backup_jobs.asp.

about recovery, I am confused with what u said, do I have to change it to simple before doing re-building indexing and full after it's...