check the monitoring server ....see when was the latest file backed up copied and restored if theres is any discrepancy let us know ........anything in the error log ???

guess the path u specified does not exist or u dont have enuf privilege to that path......can u pls check the error log and let us know what is written...

hi pls refer the below link in addition to what sugesh said,

http://msdn2.microsoft.com/en-us/library/ms188902.aspx

Hi why dont u try providing IP address instead of ur server name in the alter database command.....also chek if the port u use is free by netstat -ano

Hi Shah,

refer the below query, it will tell whether your sql server and agent is running.

set nocount on

USE master

GO

Print ''

print @@servername

IF NOT EXISTS (SELECT 1 FROM master.dbo.sysprocesses WHERE program_name =...

refer

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

You can perform both by creating a new maintenance clean up task to remove obsolete files.Having applied SP2 everything shud be fine.

Well i dont think so,...

In addition to what Sugesh said,jus fyi

http://support.microsoft.com/kb/918992   ---How to transfer logins and Pwds b/w instances of sql2005

http://support.microsoft.com/kb/224071   ---How to move sysdbs in sql 2000 and sql 2005

Hi Maddy,

Perform the following steps,

Restore database DBname from disk = 'Full path of ur full backup" with NoRecovery

Restore log DBname from disk = 'Full path of ur 1st tran log backup" with NoRecovery

Restore log...

since it can be 24 hrs old u can go for Database snapshot if u can afford for sql 2005..but cant modify db snapshot it can be used only for...

Hi,

    If u want to delete a file from a filgroup,u need to ensure that the file is empty.http://msdn2.microsoft.com/en-us/library/aa258824(SQL.80).aspx

The DBCC command will move all the datas to...

then need not shrink it.......if the unused or free space in log or data file is more than 25% u can goahead with shrinking else not required.......

Hi Patel,

         I think u can go ahead with db_datareader and db_datawriter roles for the user you create in the db.

Hi Patel,

          Wat Sugesh is trying to tell is that u better ensure to hav @least some space in tran log,coz in case u perform sum bulk insert operations,the tran log...

hi hendry,

refer http://support.microsoft.com/kb/272318 .....it shud be useful!!!!chek it..perform backup log with truncate_only option to truncate the uncommitted transactions from the log file and then perform shrinkfile or thru GUI...it shud...

s u right refer this link http://msdn2.microsoft.com/en-us/library/ms178653.aspx which says what privileges are required for using this proc.....but if u r able to create db with dbo then it shud work