Returning data from a backup to its original location or to its successor.

learn more… | top users | synonyms

6
votes
3answers
17k views

How can I back up a table structure but NOT its data in MySQL

I am using MySQL Administrator for making my database backup. I can perfectly back up the whole database with all its tables. There are some tables whose size is very big so I wonder if I could only ...
0
votes
2answers
364 views

MySQL dump-restore replaces characters with 3Fh

FreeBSD Server with Mysql and make.conf like that .if ${.CURDIR} == ${PORTSDIR}/databases/mysql50-server WITH_CHARSET=cp1251 WITH_COLLATION=cp1251_bin BUILD_OPTIMIZED=yes BUILD_STATIC=yes .endif .if ...
1
vote
3answers
4k views

WSS 3.0 Backup/Restore Root Site Collection to Sub-Site of New Site Collection

Our intranet was originally setup to be at the root of its site collection. We are trying to change this so that our new internet site will live in the root and the intranet will be a sub-site. At ...
0
votes
4answers
3k views

Import old database from the crashed SharePoint server

I have a SharePoint server have its configuration database, this server is down, when I try to access it it is gives me error: "Cannot connect to the configuration database" so I installed ...
0
votes
1answer
397 views

System State restore

I am unclear about the System State restore. Suppose I restore the System State followed by reinstalling my other Programs (Visual Studio, etc.). In such case the registry value is updated with the ...
5
votes
4answers
8k views

Does restoring a SQL database from backup rebuild its indexes?

Does restoring a SQL database from backup rebuild its tables and indexes from scratch? Or does it keep it in the same internal physical order it was in at the time of backup? We're using SQL 2000 ...
7
votes
7answers
15k views

T-SQL Script to copy a database

I would like to find a T-SQL script-based way to copy my "PROD" database (which is read-only and consists of several filegroups) to a read/writable "EDIT" database, which I can use and edit data in. ...
3
votes
4answers
203 views

Protecting Windows Machines From Users

What are some good methods to protect staff machines from the staff who use them? I am looking for something that is totally seamless, that the user would not notice...something that would not hinder ...
2
votes
3answers
2k views

Network driver for Hyper-V restore from Windows Home Server

I have backed up Windows Server 2008 running virtualized on Hyper-V to a Windows Home Server 2008 SP1 (I know I should have backed up the VHD instead). Now I need to restore the contents of the VM ...
1
vote
4answers
10k views

How do I extract all the files in a VHD to a hard disk including permissions?

I'd like to know wha thte best way is to make an exact copy of a vhd image and pu tit onto my hard disk. I've tried xcopy but there seems to be a number of issues rlated to permissions when doing ...
10
votes
8answers
32k views

SQL Server restore a backup results in an error

I have a database in dev (SQL Server 2005 on Windows Server 2008) that I need to move to prod (SQL Server 2000 on Windows Server 2003). My process is as follows: Login to dev, open SQL Server ...