If the previous instance was not named sem5 the database user names are different. Note: These instructions assume that the default naming conventions are in use. Delete the sem5 and reporting users ( SQL Authentication method only): This process is because there is no sem5 login and a login for a database can't be created if that database user already exists. Once the database is restored to the new SQL server or instance, the sem5 and reporter database users must be deleted and a new sem5 login must be created. Using the Device option, locate and restore the.Right-click Databases in the server tree and click Restore Database.Open the SQL Server Management Studio for the new server.Copy the backup file to the new SQL server.Note: Choose to use the existing backup file or for a smaller backup file remove that path and designate a new path and file name. Right-click the sem5 database and choose Tasks > Back Up. Open the SQL Server Management Studio for the current server. Perform a SQL backup of the database and restore it to a new SQL server or instance using the following procedure: Back up and restore the database:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |