Hi,
I've got a question regarding attaching/restoring of DBs and wonder if anyone could help me out.
Does SQL Server 2000 provide a functionality to attach/restore DB automatically? ie, some kind of polling service to attach/restore DB that were detached previously?
Thanks
Danny.
No.
And why would it. There could be dozens of experimental, sample, demo, 'old' database files on the computer. It should not ATTACH anything that it is not specifically instructed to attach.
|||why not?
Imagine the scenerio where there are 100 salesman with a laptop each and each laptop running a local version of web portal supported by local MSDE backend (only relevant database will be on the machine).
A WISE script executable will be created for updates of portal and existing database. If there's a new database required, the server should be able to be aware of it an attach it automatically.
Surely there's got to be a way of attaching database to 100 machines automatically.
|||You can write scripts, you can even write stored procedures that automatically execute when the server first starts, and you can use Replication.
But if you find an 'automatic' way to attach databases, please let us know.
|||Will certainly do. "Inside SQL Server 2000" just arrived. I'll consult it instead.
|||SQL Server has no way for automatic / implicit attaching of databases. You will have to use (as Anrie indicated a SP or task to search for files). Why don′t you put that in your installer script ? As from your description, it is running on the machine where the databases reside on.
Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment