TAG

Database

How to Take SQL Server Database Offline
UPDATE 12-16-2011: If you are using ASP.NET and your website / database is live, and you want to take the database offline, you're better off putting an App_Offline.htm file in your website main directory to first take the website down for maintance (I...  more »

How to Fix Restore failed for Server while attempting 'RestoreContainer ValidateTargetForCreation'
Today I ran into the a "Restore failed for Server" error message while trying to restore a SQL Server 2008 database using a database backup (.bak) file. Below I will show you how to fix this restore error, so that you can restore your SQL Server database...  more »

How to Enable SQL Server Authentication and Windows Authentication for SQL Server Databases
Here's how you can enable SQL Server Authentication in a SQL Server 2008 database, and then add a User login and password account for connecting to the database. Open SQL Server Management Studio In the Object Explorer sidebar, right-click on the top SQL...  more »

How to Test a Database Connection String using NotePad
I just came across a way to test a data providers connection string (like a SQL Server database) with the help of a plain text file using Notepad. To investigate and test out if your connection string works, your going to want to create a UDL file. To do...  more »

How to Setup Automatic Daily Database Backups in SQL Server 2008
Are you backing up your SQL Server 2008 databases daily? You should be, especially if you don't want to lose any of your precious data that you're storing. It's incredibly easy to setup a maintenance plan in SQL Server 2008 to automatically back up one or...  more »

How to Disable "Saving changes is not permitted" dialog box (SQL Server 2008)
When using SQL Server 2008, you may receive a Save (Not Permitted Dialog) box pop-up when trying to save changes to an existing table. The dailog box reads: "Saving changes is not permitted. The changes you have made require the following tables to be...  more »

How to Transfer your local Sql Server 2005 database to your Hosting Provider’s database
If you’ve experienced as many problems as I have while trying to Import/Export my Sql Server 2005 database to a hosting provider for the first time, then hopefully this how-to will be of some assistance to you.  more »

How To Get the Knowledge to Begin Building Interactive Websites?
I would like to learn how to get the skills and education to be able to build interactive websites. Can you give me some help and explain how to get started?  more »

Ask a Question

Article Categories

Follow Us