Microsoft SQL Server error appears in my all database backups

Asked By Hollis Riley 100 points N/A Posted on - 11/01/2012

Hello everybody,

Please read my problem and post your answers.

Quote:

Warn 

[Local Copy] No database file found for 'Microsoft SQL Server 

SERVERNAME (local)DATABASENAME'

 

The above error appears in my all database backups. Recently I changed the server host name and since then I keep getting this. The server hasn't at all. It's down to a change in ISP and IP at the server end.

 

So I can see why the error is occurring – The old backups are in a different folder with the old server's host name. I can see looking around the local data store for the backups that things are organized under folders with names of the host name of the server.

 

I could not get to know the exact reason for this. Please share your experiences.

 

I’ll be grateful to you!

 

Thank you.

• Status: Open
• Question Views: 900
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By DZN1444 0 points N/A #133832

Microsoft SQL Server error appears in my all database backups

Hi Hollis Riley,

Normally, this error occurs when server host name has changed  as well as you haven't configured your database properly.

In database backups, it stores all the information about all the data existed at the time you took the back up.

Since you have changed the server name backups can't fine the old path. That's the reason for getting that error.

solutions

Try old server name. That will really work

Try virtualbox and install server freshly and try backups with old server name.

If it does not work you'll have to reinstall SQL server .

 

 

 

 

 

About DZN1444

Questions
0

Answers
1

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 11/02/2012
• Question Category: MS SQL Server