Frequent use of attach and detach
From: Terris Linenbach (nospam_at_nospam.com)
Date: 03/16/04
- Next message: Erland Sommarskog: "Re: Unicode Encoding in SQL Server 2005 (Yukon)"
- Previous message: SniperX: "Error 7201: Could not execute procedure on remote server "repl_distributor' because SQL Server is not configured for remote access."
- Next in thread: Greg Linwood: "Re: Frequent use of attach and detach"
- Reply: Greg Linwood: "Re: Frequent use of attach and detach"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 16 Mar 2004 15:36:31 -0800
We are considering an architecture in which "detach" and "attach" are used
on a daily, automated basis for about 50 databases, each containing about 10
gigs of data.
We use network attached storage (Network Applicance).
We want to have a farm of load servers for a data warehouse. When a load
server in the farm is available, it "attach"es a local database to a raw
database file "F" and loads data. After loading data, the database is
detached. Another server later detaches its local database file and
attaches to file "F."
This scheme frees personnel from manually configuring servers around
unpredictable load times. It is virtually impossible for a human to
optimally allocate and schedule machines for this task.
We contacted MS tech support to get their feedback and they don't advise
such a strategy. The consequences of frequent use of "attach" and "detach"
are unknown, according to tech support. This seems a little strange to me,
since "attach" and "detach" are real features.
Has anyone tried to do something like this?
Thank you.
- Next message: Erland Sommarskog: "Re: Unicode Encoding in SQL Server 2005 (Yukon)"
- Previous message: SniperX: "Error 7201: Could not execute procedure on remote server "repl_distributor' because SQL Server is not configured for remote access."
- Next in thread: Greg Linwood: "Re: Frequent use of attach and detach"
- Reply: Greg Linwood: "Re: Frequent use of attach and detach"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
