.BAK extension file ??

[Miaaa Mukherjee]

CAN anyone tell me how can i restore the .BAK extension file ??Please tell me the steps what should be done to restore the file as i m not at all aware of how to restore the .BAK file.Can i directly restore it to SQL Server 2005 which i m using.It does not contain the name with that database in it.

The file may contain the initial previous extension of MS Access,SQL Server,Oracle or MS Word.

The file contains the database details.

Please tell me Can anyone help me with this?

Thanxs if u reply

[e-mail]

[almaz]

BAK extension are usually used for SQL Server database backup files.

1. Open SQL Server Management Studio, login to required instance of SQL Server. Right-click on Databases, select "Restore Database".
2. In the [Destination for Restore] section specify a new name for database to restore backup to, in [Source for restore] - click on the [From Device] radio button, and click browse (three dots) next to it. Select your backup file, click OK. Make sure that check box is selected in the list of backups.
3. Select Options page (on the left).
4. Verify (and possible fix) the paths to the database files in the [Restore the database files as:] list. Normally they should point to SQL_SERVER_DIR\MSSQL.1\MSSQL\DATA\DBNAME.mdf and SQL_SERVER_DIR\MSSQL.1\MSSQL\DATA\DBNAME_log.LDF, where SQL_SERVER_DIR - The SQL Server folder (usually C:\Program Files\Microsoft SQL Server), DBNAME - name of the database
5. Click OK to start restoring process

[Miaaa Mukherjee]

thanxs for replying.........

i was using first of all SQL Server 2003 and now just installed SQL Server 2005 with that of Visual Studio.Net 2005 which is much different i think.

can u just point the steps and explain me where all the database are stored in SQL 2005 from where we can go to DATABASE where all the tables are stored ??

Thanxs

[Miaaa Mukherjee]

Please give the reply.........

Is it same for 2005 & 2000 SQL Server.

Where the tables are stored in SQL Server 2005 ?????????????????

[almaz]

There is no SQL Server 2003, there are 6.5, 7.0, 2000 and 2005.
I didn't understood your question, do you want to know where databases reside physically? or logically?
Physically database is stored in several files that are divided into DATA files and LOG files.
Logically - databases are registered in the master database, that contains information about available databases, their status, user rights and so on.

Tables are stored inside DATA files, SQL Server knows about them through system tables containing information about user objects like indexes, tables, columns, stored procedures and so on.

Tables can be created using SQL Management Studio (SQL Server 2005) or Enterprise Manager (SQL Server 2000). Also they can be created using create table SQL statement. Use Books Online for more information.

P.S. From what I see you don't understand the functionality of SQL Server. See SQL Server Architecture Overview

[prathima saraf]

hi everybody,

I have got some problem while restoring database from sql server 2000 to sql server 2005. The problem is
My database is created for some login say x in sqlserver2000.
so to retrieve when i say
select * from tablename; its working fine.
After creating database in sql server 2005 and restoring ,
to retrieve data, when i say
select * from tablename; its giving error invalid object tablename....
but if i say select * from x.tablename ; its working fine...
where x is login name....
y is it so?
iam using these queries in my code, so i have to change my code now. so how is it possible to run the queries without using loginname.

what exactly is schema here... is schema n login one and the same...


can anyone please help me out....
I would be greatful to u
thanks in advance