Computer Learning, My Free Writing on Computer and Information technology

For instance, you have a data on remote/other database and you want to migrate it onto your local sql server’s database. If you use this query select * ServerName.DataBaseName.dbo.TableName you’ll find an error saying that the database cannot be found. That’s what i faced yesterday.

So you have to execute the query ” execute sp_addlinkedserver database_name just like what the error message suggested. It should then worked fine And you’ll be able to access the tables and databases from that remote database server.

Above method only works if you have two sql servers with identical name.

Tags: sql server, sql problem, ms sql

Here’s the steps:

1. Make a backup of your database on SQL 2000
2. Then move the backup to the new SQL Server 2005 server
3. Perform a restore in the SQL Server 2005.
4. The database will be up instantly.
5. Set the compatibility level of the new database that is created in SQL 2005 so that it match SQL 2000 before performing the restore process.

PS:

1. But remember that You can’t backup database on 2005 and restore it to 2000 since there is no backward compatibility works.
2. Do not forget to map the user to the database too.

Tags: sql server 2000, sql server 2005, microsoft, sql server