|
Creating an SQL Server database from a backup file
|
If you've ever created a backup of an SQL Server database you may have experienced difficulties in restoring or deploying the backup to another server. In many cases the backup will need to be used as a way of deployment to a different server, but this causes an issue if the original database isnt already attached to the target server. A database can be created from a backup file using a simple SQL query.
Within Microsoft SQL Server Management Studio (2005 or 2008), login to the target ser...
|
|
|
Published
11 March 2009
|
Author
scadadev.com
|
Views
3103
|
|
|
|
Creating an SQL Server database from a backup file
|
If you've ever created a backup of an SQL Server database you may have experienced difficulties in restoring or deploying the backup to another server. In many cases the backup will need to be used as a way of deployment to a different server, but this causes an issue if the original database isnt already attached to the target server. A database can be created from a backup file using a simple SQL query.
Within Microsoft SQL Server Management Studio (2005 or 2008), login to the target ser...
|
|
|
Published
11 March 2009
|
Author
scadadev.com
|
Views
3103
|
|
|
|
ASP.NET Report Viewer Control Issues
|
Rendering Problem in Internet Information Services 7:
When using the SQL Server Reporting Services (SSRS) Report Viewer control, an issue can occur when published through Visual Studio 2008 and used under Internet Information Services (IIS) 7. This Issue occurs because Visual Studio 2008 compiles the Report Viewer web project for use within IIS 6, and sets the Web.Config file settings to reflect this. In order for the report viewer control to work under IIS 7 the Http Handler setting must ...
|
|
|
Published
28 March 2009
|
Author
scadadev.com
|
Views
5666
|
|
|
|
ASP.NET Report Viewer Control Issues
|
Rendering Problem in Internet Information Services 7:
When using the SQL Server Reporting Services (SSRS) Report Viewer control, an issue can occur when published through Visual Studio 2008 and used under Internet Information Services (IIS) 7. This Issue occurs because Visual Studio 2008 compiles the Report Viewer web project for use within IIS 6, and sets the Web.Config file settings to reflect this. In order for the report viewer control to work under IIS 7 the Http Handler setting must ...
|
|
|
Published
28 March 2009
|
Author
scadadev.com
|
Views
5666
|
|
|