http://www.sqlservercentral.com/columnists/vIacoboni/moreintelligentbackupandrestore.asp
Run the commands that are listed in the files in the SQL Query Analyzer which create the SQL procedures in the master database.
Then run the restore command such as:
EXEC sp_ABRestoreDb 'dbDNNcreative', 'E:\Program Files\Microsoft SQL Server\MSSQL\BACKUP\09-28-06-DNNcreative' To restore the file that you have backed up to the database you have already created in SQL Server.After this, then need to run this to allow users to login to the database:
EXEC sp_abFixUserLogins
Subscribe to the website - Sign up now for just $79.97 USD per year!
Subscribe to the website Sign up now for just $79.97 USD per year!
New Releases