Moving your database from one server to another in SQL Server 2008 can be done using a variety of ways through SQL Server tools.
I. Detach the database from the server to which it is currently attached and then attach it to the new server. You can accomplish this using SQL Server Management Studio as follows:
Detaching a database using SQL Server Management Studio:
- Open SQL Server Management Studio. In the Object Explorer, set connection to the SQL Server Database Engine instance and then expand the instance.
- Click ‘Databases’ and choose the database you need to detach.
- Right-click the selected database, click ‘Tasks’, and then ‘Detach’. The ‘Detach Database’ dialog box is displayed.
- Check if the database you need to detach is displayed in the ‘Databases to Detach’ grid.
-Select the ‘Update Statistics’ check box if you want to update the current optimization statistics for your database.
- If the column displays ‘Not Ready’, additional hyperlinked information about the database is provided in the ‘Message’ column. If the database is used for replication, the ‘Message’ column shows ‘Database Replicated’. If there are active connections to the database, the ‘Message’ column shows ‘ Active connections’. To remove all the active connections, you should select the ‘Drop Connections’ check box.
- If you are ready to initiate the process, click ‘OK’.
- Attaching a database using SQL Server Management Studio:
Launch SQL Server Management Studio. Open Object Explorer, connect to the SQL Server database Engine instance, and expand this instance.
Right-click ‘Databases’ and select ‘Attach’.
An ‘Attach Databases’ dialog box will be displayed. In this dialog, click ‘Add’. In the ‘Locate Database Files’ dialog box, locate and select the ‘.mdf’ file of the database you need to attach.
You can also give the database a different name while attaching it to the SQL Server instance. To do this, type in the desired name in the ‘Attach as’ column on the ‘Attach Databases’ dialog box.
You can also change the database’s owner by providing a different name in the Owner column on the dialog box.
- After finishing with the above steps, click ‘OK’.
The entire process is performed offline and does not copy the database, rather transfers the file from one server to another.
II. Take a backup of your database on the old server and then restore this backup on the server to which you want to move your database. This is an online process that results in the creation of a new database on the destination server.
Different types of SQL Server backups:
Full database backup consists of everything within your database including the transaction log. This type of backup will exclude unallocated extents in the files.
Differential backup contains only the newly allocated or changed extents. They keep track of all the changes done since the last full database backup.
Transaction log backups contain all the changes made to your database. These changes are recorded serially. With these backups, you can easily restore your database to a desired point in time.
The foremost step in backing up and restoring SQL Server databases is to devise a backup and restore strategy, considering the available resources and time. A backup strategy will determine the type of backups and their frequency. If you choose to backup only the database, you will lose all the modifications done by transactions since the last full database backup. In case you plan to backup database with the transaction log, you will lose only the uncommitted changes.
III. If you intend to copy your database, you can do so using the Copy Database wizard in SQL Server Management Studio.
Follow the procedure given below to copy or move a database and its objects from one server to another using the Copy Database Wizard:
- Open SQL Server Management Studio. In the Object Explorer, right the database you need to move, select ‘Tasks’, and click ‘Copy Database’.
- Specify the source server on which the database to be copied resides.
- Specify the destination server to which you need to copy your database.
- Specify the database to be moved or copied.
- Provide a different name to the target database in case name conflicts exists on the destination server.
- Specify the other objects you need to copy or move to the target database, such as logins, shared objects, maintenance plans, etc.
- Fix a desired schedule for the copy operation.
- Provide a SQL Server Agent Proxy account that has permissions to access the Integration Services (SSIS) Package execution subsystem.
When databases are copied from one server to another, the Copy Database Wizard checks whether the database is online after completing the scheduled task.
About the Autho
r: Jyoti Prakash is Sr. Technical writer who has written several article on How to recover SQL server data
from corrupt mdf file, without backup, and from suspect mode.
It is commonplace for organizations and even small business setups to use MS Outlook nowadays. In addition, the home users depend on this application for managing their email data. It incorporates a set of powerful tools to keep your information safer and help prevent losing work. However, you may sometimes end up deleting your business-critical emails in an attempt to clean up the mail folders in your Outlook PST file. This can have a serious impact on your business.
There are three different ways in which you can delete emails in MS Outlook.
I. Using ‘Delete’ Key:
This is pretty simple and quick way of deleting items in MS Outlook. You can select an item in your mail folder and press the ‘Delete’ key on the keyboard. You can also do this by highlighting the item and then clicking ‘X’ icon on the Outlook toolbar. The items deleted by this method are moved to the ‘Deleted Items’ folder. You can go to the ‘Deleted Items’ folder and restore these items to their original location. To permanently delete the items, click ‘Empty Deleted Items Folder’ on the ‘Tools’ menu.
II. Using Shift + Delete:
This method is also known as ‘Hard Delete’. Most Outlook users do not want to take pains in order to delete those items that consuming their valuable quota space on the server. They tend to permanently delete items by using the ‘Shift+Delete’ key combination. The deleted items are not moved to the ‘Deleted Items’ folder. So, you cannot recover them through a simple restore. This can also be done by pressing the ‘Shift’ key and clicking the ‘X’ icon on the toolbar at the same time.
III. Moving Emails to a PST File:
When you move items from your Outlook mail account to a PST file, they are permanently deleted from your mailbox. You will not be able to find them in your mail account after this move.
MS Outlook 2007 allows you to easily recover items that are permanently deleted from your mail account. To do this, you need to use a Microsoft Exchange Server 2000, Exchange Server 2003, or Exchange Server 2007 account.
The Exchange administrator sets a retention time for all the items that are permanently deleted on the server. You can only recover the deleted items within this time.
Below mentioned is the procedure for recovering deleted items using the ‘Recover Deleted Items’ feature in MS Outlook:
• Navigate to the folder from where you deleted your emails. Click ‘Tools’ and then select ‘Recover Deleted Items’.
• The ‘Recover Deleted Items’ dialog box is displayed. Choose an item to be recovered and then click ‘Recover Selected Items’.
• Each recovered item will be restored to the respective folder from where it was deleted.
In case you are not using MS Exchange Server, you can still recover your deleted Outlook emails through professional Deleted Email Recovery software
. These tools have a knack of scanning the entire Outlook PST file for retrieving your deleted emails with the original formatting and text. These tools are fast, reliable, and risk-free. Further, they support MS Outlook 2007, 2003, 2002, and 2000
Today there are only few people who take a site as just a hobby. It goes without saying that your business or job position depends on the website workability. The irretrievable loss of the latest version of files and databases can be just a pity, but in most cases it can be a tragedy, like a loss of source of income.
Of course, today’s hosting providers are reliable enough and such cases are few and far between, but they are not so rare to ignore them. The sites are hacked damaging the data base and infecting files. Also server software failures or even fires in data centers can happen.
The web hosting control panels, such as DirectAdmin, cPanel, ISPConfig, GPLHost, ISPmanager have different ways to backup sites. BUT it’s worth checking up if you can restore the site from backup copy made by these means. You may face the next difficulties – backup is done rarely, irregularly, and sometimes it does not exist at all. Big sites have another problem – the backup fill the place given by the provider for the website itself, that’s why you can’t make copies frequently because of the rapid filling of disk space.
But there is another problem – a copy of the site can be physically present at the same hard drive as the site itself and if it’s crashed, both of them(the website and backup) simply disappear.
Small and medium-sized hosting providers often neglect the use of serious backup systems, because it costs more. And the standard means of backup service used by hosting providers are not always fully workable. We don’t talk about large hosting services, for which such data loss can severely hit their reputation, but there are over 20,000 web hosting providers and not all of them are giants. If you think about the additional data backup of your site, it is easy to do – you can merge the backup files of your site using any free FTP client such as FileZilla, and creating a dump of the database through PhpMyAdmin – just select your database and click “Import” button.
It can easily be a part of your daily routine, combining for example with the morning coffee. If there are multiple amount of sites, so your coffee can be outlasted , that is why you should intrust the program BackupSF (http://www.backupsf.com
/) with this routine. The program’ll independently and regularly backup files of your site and database on your local computer. You’ll just need to enter username and password, database name data, user and password and the address of the database server and set a regularity of backup. If you do not trust the reliability of your hard drive – use the sync folder of Dropbox, SugarSynk, Google Drive, or a similar cloud service storage as backup folder in the programe BackupSF.
The data backup is considered to be the most reliable if only the backup copy is stored in three different places. They are – a backup done by your hosting provider + copy on your PC + copy of your web site in the cloud service – you can be completely tranquil.
Author Bio : Post Submited by Liliya
offers one of the largest free storage’s for you to keep your files at hand. 4Sync provides 15 GB
of storage space online. Another 4sync benefit is its sync applications for such operating systems as: Windows, Linux
and Mac OS
as well as for Android
phones, iPhone, Blackberry
It uses practically the same technology other file synchronization services offer.
4sync creates a folder on your desktop where the program is installed. All files and folders are copied to this folder and automatically synchronized with your online storage.
If you install 4Sync program on other computers or mobile devices the files will also be synchronized with them.
This way you can access important files from anywhere once you install the application on your computer.
The first thing you need to do is to log in the application and create a free account.
By default the application creates a 4sync folder
within the user folder but you can select another location for the folder. It’s a final installation step of the 4sync application.
4sync app’s icons are placed on the background of the system tray
To open the 4sync folder double click on the icon.
You can also open 4sync folder via your operating system file manager clicking the 4Sync icon.
You can open your 4sync account, browse files, keep track of the used space, the history of synchronized files and access the application options.
You also can define the location of folder, set upload and download limits for the synchronization of files, configure a proxy.
Among other options you can also access your synchronized files and folders from computers that do not have the program installed.
Just visit 4sync website, login to your account to access the 4sync files.
Download 4sync for Android, iPhone, Blackberry and Symbian.
Note: During installation of the application it offers to install the 4shared toolbar which is unnecessary for the application execution.
Stay tuned and uncheck this option if desired.
About Author: This Post is written by Sam Gilmore