RE: How do I restore from mdf and ldf files?



Start -> Program Files -> Microsoft SQL Server -> Enterprise Manager ->...
TO BACKUP:
Right Click on <name>_Config db folder -> Right Click -> Properties -> All
Tasks -> Backup Database
TO RESTORE:
Right Click on <name>_Config db folder -> Right Click -> Properties -> All
Tasks -> Restore Database
-> From Device -> Select Devices -> Add -> FileName
This works with .bak files.
do update me.
Copy the following and paste in MS Word.
Pre-requisites for Sharepoint Installation:

1) Make Sure System is in Network.
2) Make Sure No Two Systems has the same IP.
3) Make Sure, No Two Systems are Logged in with the same Username, Password
and Domain.
4) Do Not Logon to the System with the Standalone Username, Password, and
System name as Domain.
5) Do the Complete Installation with the Same Login Details.
6) The Username, Password, and Domain with which we Login, Must be in the
Power Users Group.


Step by Step Sharepoint Installation:

Step 1: Windows 2003 Server with Latest Service Pack
Step 2: Restart the System. Login with the User which is in Power User Group
Step 3: IIS 6.0 with ASP.NET Support (No Front Page Support)
Step 4: Restart the System. Login with the User which is in Power User Group
(Same)
Step 5: Install SQL 2000 (Provide the same Windows Login details
During Installation)
Step 6: Restart the System. Login with the User which is in Power User Group
(Same)
Step 7: Install SQL 3a or Latest Service Pack
Step 8: Restart the System. Login with the User which is in Power User Group
(Same)
Step 9: Make Sure IIS is running and SQL Database is running.
To Restart IIS: Start  Run  IISRESET
SQL Database: Bottom Right Corner (System Tray) Check whether Database is
Running or Stopped.
Step 10: Install Sharepoint Portal Server 2003 (Without Database Engine
[MSDE])
Step 11: Reset IIS (Start  Run  IISRESET)


Step by Step Sharepoint Uninstallation Procedure:

Step 1: Restart the System. Login with the User which is in Power User Group
Step 2: Start  Settings  Control Panel  Add or Remove Programs
Step 3: Click on Change button next to Microsoft Office Sharepoint Portal
Server 2003
Step 4: Click on Next  Select Remove Radio Button  Next … and follow the
user
Interface instructions.
Step 5: After Successful Uninstallation Message. Click OK.
Step 6: Click on Remove button next to Microsoft Windows Sharepoint
Services 2.0
Step 7: Remove Databases from SQL Server
Start  Programs  MS SQL Server  Enterprise Manager  Expand
Microsoft SQL Servers  SQL Server Group  Local  Databases 
Right click on Database Name (SPS01_Config_db)  Delete
Right click on Database Name (<Name>_PROF)  Delete
Right click on Database Name (<Name>_SITE)  Delete
Right click on Database Name (<Name>_SERV)  Delete
Step 8: Restart the System.










Pre-requisites for Sharepoint Backup and Restore:


1) Production, Test, and Restore Servers MUST and SHOULD have the same
Software
Configuration namely (Windows 2003 Server with Latest Service Pack, IIS, SQL
Server with Service Pack(SP3a or SP4), Sharepoint Portal Server 2003).
There must not be any variations at all. If exists any, It will result in
Backup/Recovery failure.
2) Make Sure both the Systems are in Network.
3) Make Sure No IP Conflict exists.
4) Make Sure (If possible, name the Production, Test, and Restore Servers
with the same name but Different IP’s) Because, If the Production Server is
down we can restore the same on Test Server and we can use the same URL to
access the site.
5) Login Authentication - Username, Password, and Domain MUST be in the
Power User Group.
6) Do not Logon to two systems with the same Username, Password and Domain.
7) Make Sure NO USER is logged on to the Server. Before we backup the
server, restart the server so that no user is logged in and then Backup the
server.



Sharepoint Backup

Step by Step Sharepoint Backup Procedure


Step 1: Make Sure No Users are connected to the Sharepoint Portal Server
Note: - If Users are accessing Sharepoint there is a possibility that
Backup OR
Recovery May Fail (Suggested by Microsoft).
Step 2: Restart the System. Login with the User which is in Power User Group
(Same).
Step 3: Create a Folder on the Local Hard Drive for backup files
Step 4: Start  Programs  Sharepoint Portal Server  Sharepoint Portal
Server Data
Backup and Restore.
Step 5: Start the SharePoint Portal Server Data Backup and Restore tool.
Step 6: Click the Backup tab.
Step 7: In the Backup location and name box, specify the location where you
want to store
the backup files. Additionally, specify the file name to use as a prefix for
the backup
files.
Step 8: Expand Available components, and then click All server farm
components. Verify that
the Ready check box is displayed next to the items that you want to back up.
Additionally, verify that the Ready check box is selected for each item that
you want to back up.
Step 9: Click Backup.
Step 10: Click OK when you receive the message that states that the backup
operation
Completed successfully.
Step 11: On the File menu, click Exit to quit the SharePoint Portal Server
Data Backup and
Restore tool.







Back up the databases in SQL Server 2000
Back up the following databases in SQL Server 2000:
1. PortalSiteName _PROF
2. PortalSiteName _SERV
3. PortalSiteName _SITE
4. The SharePoint Portal Server 2003 configuration database. By default,
this database is named SPS_Config_db.

To do this, follow these steps:
1. Create a new folder on the hard disk drive to store the databases that
you back up.
2. Start SQL Server Enterprise Manager. (Start  Programs  Microsoft SQL
Server  Enterprise Manager)
3. Expand Microsoft SQL Servers, expand the server group, expand the
appropriate server, and then expand Databases.
4. Right-click the database that you want to back up, point to All Tasks,
and then click Backup Database.
5. If a path is displayed in the Destination box, click the path, and then
click Remove.
6. Click Add. Click File name, and then specify the location of the folder
that you created in step 1 and the file name of the backup file. Use a file
name that is the same as the name of the database. For example, when you back
up the PortalSiteName _PROF database, specify the file name as PortalSiteName
_PROF.
7. Click OK three times.
8. Click OK when you receive the message that the backup operation completed
successfully.
9. Repeat step 4 to step 7 for each database.

Sharepoint Restore

Step by Step Sharepoint Restore Procedure.

INSTALL SHAREPOINT PORTAL SERVER, BUT DO NOT CREATE A PORTAL SITE.

Step 1: Make Sure! The System on which we are about to recover Sharepoint is
Loaded with
all the pre-requisite softwares (same as in Production Server)
Step 2: Make Sure! IIS is running and SQL Database is running.
Step 3: See if the Existing Default Virtual Server can be extended or else
Create a new
Virtual Server, which will be used during recovery of Sharepoint.

How to create a virtual Server (New Web Site) on IIS?

Start  Programs  Administrative Tools  IIS Manager
OR
Right Click on My Computer  Manage  Expand Services and Applications 
Expand Internet Information Services (IIS) Manager  Right Click on Web
Sites 
Next  Description of the Website (Name of the Virtual Server)  Next 
Retain the
First two fields by default, Host Header name = the name given in previous
screen Description of the Website  Next  Click on Path  Expand C: - expand
Inetpub – click on wwwroot – click on Make New Folder Button and give the
name. – Click OK  Uncheck Allow Anonymous Access to this website  Check
Read and Run Scripts  Next  Finish.
Step 4: Start  Run  IISRESET
Step 5: Make Sure! All the websites are running under Web Sites in IIS Manager





How to Create a Virtual Server?

First Create an Application Pool

Step 1) Start  Settings  Control Panel  Administrative Tools  IIS
Manager 
Expand (+)  Right click on Application Pools  New  Application Pool

Second Create a New Website

Step 2) Start  Settings  Control Panel  Administrative Tools  IIS
Manager 
Expand (+)  Right click on Web Sites  New  Web Site  Set a New Home
Directory here and give a new Port Number
Step 3) Later right click on the new website... go to Properties... Go to
the Home Directory
Tab here in the application pool list. Select the one that you created.  OK
Step 4) Start  Run  IISRESET

To restore SharePoint Portal Server 2003 data from a backup, follow these
steps:

1. Start the SharePoint Portal Server Data Backup and Restore tool.
Start  Programs  Sharepoint Portal Server  Sharepoint Portal Server Data
Backup and Restore.
2. Click the Restore tab.
3. Click Browse next to the Manifest file box.
4. Locate the folder that contains the backup files, click the .xml manifest
file, and then click Open.
5. Expand Available components, and then click All server farm components.
6. Click the SITEDBS item, and then click Edit.
Note: Do not click to select the Parameters needed check box.
7. In the Portal recovery information dialog box, follow these steps:
a) In the IIS virtual server and portal URL area, verify that the following
conditions are true: 1) The Microsoft Internet Information Services (IIS)
virtual server is set to Default Web Site.
2) The portal URL is set to the URL that you want. For example, the URL is
set to
http:// ServerName.

b) In the Database information area, click the name of the database server.
Then, specify the names that you want to use for the content database, the
user profile database, and the services database.

Note: The name of the content database typically ends in _SITE. The name of
the user profile database typically ends in _PROF. The name of the services
database typically ends in _SERV.

c) Click OK.

8. Verify that the Ready check box is displayed for the SITEDBS item, and
then click to select the Ready check box.

Note: When you move databases to a remote computer that is running SQL
Server, you do not have to restore the index. However, if you want to restore
the index, make sure that the Ready check box that is next to the INDEX item
is selected.
9. Click Restore.
10. Click OK when you receive the message that states that the restore
operation completed successfully.
11. On the File menu, click Exit to quit the SharePoint Portal Server Data
Backup and Restore tool.




If Backup FAILS then:

Step 1) Uninstall Sharepoint Portal Server
Start  Settings  Control Panel  Add or Remove Programs  Microsoft
Office Sharepoint Portal Server  Change  Remove  Next  ..

Step 2) Uninstall Windows Sharepoint Services
Start  Settings  Control Panel  Add or Remove Programs  Windows
Sharepoint Services  Remove

Step 3) Remove Databases from SQL.
Start  Programs  Microsoft SQL Server  Enterprise Manager  Expand
Microsoft SQL Servers  SQL Server Group  Local  Databases  (4
Databases should be removed namely: _PROF, _SERV, _SITE, and default
Database)

Step 4) Restart the system.

Step 5) (OPTIONAL BUT REQUIRED) Uninstall IIS.

Step 6) Restart the system.

Step 7) Install IIS, Install SPS2003 (don’t create portal site), Restart
system

Step 8) Verify whether IIS is running or not, SQL is running or not.

Step 9) Restore Backup

Step 10) If the restored site doesn’t display the Portal.
Verify the following:
IIS website has the Windows Authentication Check box Checked.
Right Click on My Computer  Services and Applications  Internet
Information
Services (IIS) Manager  Web Site  Right click on Default Web Site 
Properties
 Directory Security Tab  Authentication and access control  Edit 
Authenticated Access  Check Integrated Windows Authentication.

Reset IIS: Start  Run  IISRESET


Following Services MUST be running for Sharepoint to run:

NAVIGATION: Right click on My Computer  Manage  Expand Services and
Applications  Services



1. ASP.NET State Service
2. Microsoft Sharepoint Search Service
3. Sharepoint Portal Administration
4. Sharepoint Portal Alert
5. Sharepoint Timer Service
6. Simple Mail Transfer Protocol (SMTP)
7. World Wide Web Publishing Service
8. MSSQL if SQL Server 2000 is running on the same server



"steve@xxxxxxxxxxxxxxx" wrote:

We had a share point server running on a machine called "File-server".

I do not have backups but, do have the actuall database files
STS_FILE-SERVER_1.mdf
STS_FILE-SERVER_1_log.ldf

I also have the STS_Config files.

I installed IIS and SPS on a new server called "Term-Server" and the default
site comes up.

I want to be able to access the data in the database files but, have not
figured out the correct sequence or combination to get the original site back
on line.

Can someone please point me in the right direction?

Thanks!

I want to be able get to the

.