Microsoft SQL Server error appears in my all database backups

Asked By 100 points N/A Posted on -
qa-featured

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.
SHARE
Answered By 0 points N/A #133832

Microsoft SQL Server error appears in my all database backups

qa-featured

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 .

 

 

 

 

 

Login/Register to Answer

Related Questions