Go to Windows control panel -> Performance and maintenance -> Administrative tools -> Services ->right click on SQLEXPRESS -> Properties -> Under Logon tab check Local logon and allow interact with local services.
It the above doe not work then
go to my SQL Server data folder via windows explorer (mine was: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQL), select all the files, right click, click advanced, UNCHECK, “Compress contents to save disk spaceâ€.
Linux does not restrict you from copying anything so use TAR to archive all files in one directory. (next time I will try Ghost)
1: Backing-up
sudo su [become a super user]
cd / [ mvoe to the root directory)
tar cvpzf backup.tgz --exclude=/proc --exclude=/lost+found --exclude=/backup.tgz --exclude=/mnt --exclude=/sys /
[c: to create a new archive; v: print verbose info on screen; p:preserve permissions'(to keep the same permissions on everything the same); z for file compress, it might not be a good idea to compress files, use it for non critical applicatons. f: file name]
[make sure you don’t include the file itself, or else you’ll get weird results. You might also not want to include the /mnt folder if you have other partitions mounted there or you’ll end up backing those up too. Also make sure you don’t have anything mounted in /media (i.e. don’t have any cd’s or removable media mounted). Either that or exclude /media.]
[At the end of the process you might get a message along the lines of ‘tar: Error exit delayed from previous errors’ or something, but in most cases you can just ignore that.]
2: Restoring
Make sure you are root and that you and the backup file are in the root of the filesystem.
WARNING: this will overwrite every single file on your partition with the one in the archive!
tar xvpfz backup.tgz -C /
3: Re-create the directories that were excluded:
And when you reboot, everything should be the way it was when you made the backup!
4: GRUB restore
If you installed windows or your GRUB was damaged. then
Due to some reason I uploaded a plugin called “wpaudio-mp3-player.2.1.0.zip”, which is a light weight mp3 player, to the wordpress /uploads directory. Looks like my web server do not like the word mp3 anywhere in my file name (you have to pay to get around it). so even though I was able to upload it by a program, I can not just delete it by using a command in my FTP client. The only way I can remove this file is to use PHP unlink function.
<?php
$myFile = "wpaudio-mp3-player.2.1.0.zip";
unlink($myFile);
?>
Save this to a php file and upload it to the same directory that I want the file to be deleted. then run this php, I’m done. Apparently php uses similar syntax to the Unix C unlink() function. Everyone thinks there should be a delete command, php.net even has a delete dummy entry only point to the unlink command.