Backup and restore of databases

last week in the maintenance of 3 sites (psychology, history, pedagogy), encountered in the background of the site does not go into the problem, probably reported database errors.

Can first go to the root directory to find there is no admin_loginxxx.aspx this file, thus judging there is no backstage, there is no database

1, first restore the database (the need to restore the database **.bak file to find a place to save up, I then put the e-packing directory, and then to the server to find the root directory of each Web site configuration file iwms.config, find the server inside the connection, database user name, password

2. Open SQL Server Management Studio Database General--------------source device--------------add; option-----tick First (overwrite existing database)

3, if the Iwms.config file is empty, then create a new database, restore the database, if there is already in the target database, then restore directly; if not, create a new one, then restore

Publish a Web site to 70 (local) from a 253 (extranet) server

1. SQL Server RESTORE Database

2. Advanced firewall----Inbound----port number

If the 253 backstage can go in and from 253 copy to 70 will not go to display the user name or password error?

Resolution: 1. Restart the application pool

2, or the current login to the background of the user to change to a senior administrator, the rights of ordinary users are not in the background

have been waiting for the background of the section of the password is not in?

Far from the root directory----Find db----iwms.cs------suffix to. mdb-----------Double-click to open the Office----------Access-------Database (decode)

To ensure that the external network and the background password of the intranet consistent:

Database-------table-------dbo.iwms_member---------Right-click----Display the first 200 rows of data-------display the corresponding password for each user

Backup and restore of databases