|
Home > Archive > MS SQL Server > February 2006 > Location of Logs and data files
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Location of Logs and data files
|
|
| Petet Tickler 2006-02-16, 7:23 am |
| Do the logs and data files of a database have to be on the same server as the
SQL Server software?
I am running SQL Server 2000, and have several DBs on the server. However I
am expecting a new one to grow quite fast, and would like to place the data
and log files on a separate server. However, when I create a new DB and try
to locate the data and log files elsewhere, it only appears to allow me to
place them on the same server. Is there any way round this??
| |
| Tibor Karaszi 2006-02-16, 7:23 am |
| > Do the logs and data files of a database have to be on the same server as the
> SQL Server software?
Yes. They can be on a SAN, though, as a SAN is seen as locally attached..
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www. solidqualitylearning
.com/
Blog: http:// solidqualitylearning
.com/blogs/tibor/
"Petet Tickler" <Petet Tickler@discussions.microsoft.com> wrote in message
news:60DF8C3F-8C66-4FB9-9731- 569DE8B3F832@microso
ft.com...
> Do the logs and data files of a database have to be on the same server as the
> SQL Server software?
>
> I am running SQL Server 2000, and have several DBs on the server. However I
> am expecting a new one to grow quite fast, and would like to place the data
> and log files on a separate server. However, when I create a new DB and try
> to locate the data and log files elsewhere, it only appears to allow me to
> place them on the same server. Is there any way round this??
>
| |
| Steen Persson (DK) 2006-02-16, 7:23 am |
| Petet Tickler wrote:
> Do the logs and data files of a database have to be on the same server as the
> SQL Server software?
>
> I am running SQL Server 2000, and have several DBs on the server. However I
> am expecting a new one to grow quite fast, and would like to place the data
> and log files on a separate server. However, when I create a new DB and try
> to locate the data and log files elsewhere, it only appears to allow me to
> place them on the same server. Is there any way round this??
>
Having you database files on another server, is not enabled in SQL Server.
If you have a NAS, you can have your files on this, but it's not
recommended.
http://support.microsoft.com/defaul...kb;en-us;304261
Regards
Steen
|
|
|
|
|