cancel
Showing results for 
Search instead for 
Did you mean: 

init file

Former Member
0 Kudos

Hi All

I am new to SQL. Can anyone tell me where can i find the initialization file for MS SQL server. In oracle the file is init<SID>.ora.

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member185954
Active Contributor
0 Kudos

Hi,

MSSQL doesn't have any such file, it stores the configuration data in system databases.

Each instance of SQL Server has four system databases (master, model, tempdb, and msdb) and one or more user databases.

when you create a database , it simply copies the model database, the master database has information about the user databases.

Check the following link:

http://msdn2.microsoft.com/en-us/library/aa214422(SQL.80).aspx

Regards,

Siddhesh

former_member185954
Active Contributor
0 Kudos

Here is some more info:

System Databases and Data

Microsoft® SQL Server™ 2000 systems have four system databases:

  • master

The master database records all of the system level information for a SQL Server system. It records all login accounts and all system configuration settings. master is the database that records the existence of all other databases, including the location of the database files. master records the initialization information for SQL Server; always have a recent backup of master available.

  • tempdb

tempdb holds all temporary tables and temporary stored procedures. It also fills any other temporary storage needs such as work tables generated by SQL Server. tempdb is a global resource; the temporary tables and stored procedures for all users connected to the system are stored there. tempdb is re-created every time SQL Server is started so the system starts with a clean copy of the database. Because temporary tables and stored procedures are dropped automatically on disconnect, and no connections are active when the system is shut down, there is never anything in tempdb to be saved from one session of SQL Server to another.

By default, tempdb autogrows as needed while SQL Server is running. Unlike other databases, however, it is reset to its initial size each time the database engine is started. If the size defined for tempdb is small, part of your system processing load may be taken up with autogrowing tempdb to the size needed to support your workload each time to restart SQL Server. You can avoid this overhead by using ALTER DATABASE to increase the size of tempdb.

  • model

The model database is used as the template for all databases created on a system. When a CREATE DATABASE statement is issued, the first part of the database is created by copying in the contents of the model database, then the remainder of the new database is filled with empty pages. Because tempdb is created every time SQL Server is started, the model database must always exist on a SQL Server system.

  • msdb

The msdb database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators.

Former Member
0 Kudos

Hi Christian,

initSID.ora or *.sap only works for Oracle databases

Check following link:

http://help.sap.com/saphelp_nw04s/helpdata/en/0d/d308f14a0c11d182b80000e829fbfe/frameset.htm

Regards,

Marcin Gajewski