Normally you can delete all the log files once a full or diff back has been done.... as i our env we've a staging area where all the backups get...

See it seems to be some file mismatch issue.

Try below

1. Backup destination db.

2. Delete this db. (Anyhow this will be overwritten)

3. Restore the db using move options if you want...

Adiga (8/4/2010)

---

I assume you are trying to take the backup using SSMS and the destination is referring to the old location.

Why not use this query instead of using the GUI?

BACKUP...

I've never used light speed as such but used redgate and according to it... you can only backup & restore databases on the instance where redgate has been installed..... and...

I too agree with Ashish as if this backup is native sql backup then only you shud use SSMS or query analyzer to restore this, if this is a redgate...

See when you already have your prod server on a cluster and this exercise you're doing for the worst case scenario, then I don't think you need a more spare...

one more addition... you can also try snapshots as restoring from snapshot takes very less time as compared to full backup.

But in this case u don't have choice my friend.....

Rohit

if you're defraging the indexes then the next step of this job should be updating the statistics.

As defrag doesn't updates the statistics.... if ur reindexing it then no need to...

I agree but these thing are in place from last 5-7 years and it will be really tough for me...

This I haven't tried as I'm not sure except logins and...

Guys....... I'm not sure whether I was able to explain you as what exactly we're trying to do..... Lets start it all again....

In our comp we're not having any DR...

I don't need that backup as this was a fresh install and then I started to rebuild the server...

irena.bulatovic (3/26/2010)

---

We moved our database to several different servers till now but...

scott williams-465021 (1/19/2010)

---

I could not run any checkdb commands either. Oddly enough the tables also seem to be completely screwed up - there are tables missing and those that...

try this.

USE master

EXEC sp_configure 'show advanced option', '1'

go

RECONFIGURE WITH OVERRIDE

go

EXEC sp_configure 'allow updates', '1'

go

RECONFIGURE WITH OVERRIDE

go

--Now update the table u wanna update

begin tran

update master.sys.sysdatabases set status = 16 where name...

Guys one more thing.. if I restore differential backup on secondry in place of full backup will it work???

Sudhakara it's always a good practice to post the solution also once...