are you able to delete using xp_delete_file procedure manually running it, coz thats the procedure they are calling in the cleanup task.......

The standby servers act as a backup server.....if your production server is highly critical and you cant tolerate any downtime you can make use of the standby server.Unfortunately if the...

you can make use of xp_cmdshell to delete the old files,

xp_cmdshell 'del path\.bak' will remove all the .bak files in the particular path you specify......xp_delete_file works well in sql 2005.....it...

just try to restart your sql server agent may be your agent is hanged state......

no issues just select the correct instance you wish to uninstall and press ok it shud be fine coz i have 3 instances and i do it frequently..........

i dunno if am right   this is wat comes to my mind, since log shipping is configured i believe the db is in...

Hey you need to use Trace flag 1400 for SQL server RTM versions i believe......even i had this issue.......go to sql server configuration manager and choose sql 2005 services and...

your sql server agent is in hanged state so just restart your sql server agent service all will be fine i guess......thanks

you can refer this link,

http://dumthata.com/sqlchn/articles/install/insql.htm

refer the step 9 in that link you need to choose named instance option there and specify any name asper your desire.......cool

In one singlre server you can create 3 seperate instances and configure dataabse mirroring.....even i had done the same it works....Just run through the setup.exe as you did for installing...

Karthik,

Just do as mentioned below,

Restore database DBname from disk='Path of your backup file\Fullbackup.bak'

with norecovery

Restore database DBname from disk='Path of your backup file\Differentialbackup.bak'

with recovery

may be you...

karhtik, you need to restore the full backup with either norecovery or with standby option so that the additional tranlogs backups or differential backups cud be applied......

restore the full backup with...

just backup the tail end of the tran log using with norecovery option......so that the primary will be in restoring state and further tran logs cud be applied.........restore it in...

yes sometimes even i faced this issue but it always works from command prompt.........just start sql server in single use mode as follows,

net start mssqlserver /c /m /T3608

then detach the...

using NO_TRUNCATE option will not truncate the transaction log and is used in situations where db is damaged but in simple recovery model all the inactive transactions will be flushed out.......