Hi Pavan,

can u pls send the errorlog and sqlagentlog output when the backup was failed ???...in the error log it will be clearly specified wat happened @backup time...also if nothing...

hi pavan,

    can u pls let me know the result of job history and also the error log info?

hi dude,

          u shud commit whatever transaction u perform......then try out

if u are able to login into query analzer,try the procedure sp_resetstatus.....and restart sqlservices.else if u can login into enterprise manager,right click on the particular db and detach it and...

hi pavan,

           Did u check the recovery model? if the recovery model of your db is simple u cannot perform Transaction log backup...........only full backup is possible.May be some of...

1.try to detach the db and reattach the db,it shud come online.........

2.else execute the following procedure .....sp_resetstatus 'DBName'.after exec it u need 2 restart the sqlservices.....then check whether the db...

hi greg,

          Assume u create a table in a db called mydb @1:50 am.........

insert 5 values @ 1:55 am into the table ..........insert 10 values @ 2:05 am....

now take a...

In Sql 2005 u can perform point in time recovery with full backups but in sql 2000 u need tran log for performing point in time recovery

Rgds

Deepak

i guess it is

select * from sysobjects where xtype='U' --->for user tables

select * from sysobjects where xtype='S' ---> for system tables

also u can use sp_tables sp to retrieve the...

Hi Dude,

          No it is not needed,if u restored ur full backup today with recovery,and after some 3 days if u hav ur diff backup ,u can easily restore it normally...

Hi Dude,

          Regarding DBMail pls refer the below link,it gives the step by step methods to configure the mail,

http://www.sql-server-performance.com/da_email_functionality.asp

Cheers

Deepak

Hi,

    If it is an extremely critical DB u can  configure Logshipping or mirroring for that DB alone.Without SP2 SQL 2005 Maintenance plans have lots of problems.

Rgds

hi,

   ur 1st question has  been answered previously,as far as maintenance plan is concerned,once it is created u shudnt alter it i.e once a maint for DB backup is created,a...

hi,

   if u cud specify the query used in the job or something more specific,so that we can identify the reason.my guess is that in the output text file these...

hi,

  resourcedb in sql 2005 is a read-only DB.if u type sp_helpdb or select * from sys.databases or in the Management studio it will not be visible .......