开发者

Forward DB requests after a DB move in SQL Server

I've moved database from one SQL Server instance on a machine to another machine completely. 开发者_如何学运维 Is there any way to forward requests to the new server automatically so it doesn't require client config changes? Keep in mind it's only one DB out of many on the original server so I can't just forward all requests.


You could define an alias for your new server that is the name of the old server/instance - but that would forward all requests to the new server.

As far as I know, SQL Server doesn't have a concept of a "database alias" as of yet.

See this discussion thread on MSDN social about this topic.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜