Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [backup-restoration]

344 questions
0
votes
1 answer

Sql Server: Determining which transaction logs need to be restored

If you have (say) 10 transaction log backups and some, all or none may have been restored to the database. Is there a way to determine which files have already been restored? Thanks Dave
David Hayes
  • 442
  • 4
  • 12
0
votes
4 answers

Backup single table MS SQL SERVER

How to take a back up of single table and restore it back when I required. I mean,I need back of single table with all the indexes,constraints and data associated with that table. because I want to modify some of the data of the base table,before…
Dhiva
  • 1
  • 2
0
votes
1 answer

Best way to backup remote windows 2008 server to my local machine?

We have a remote Windows 2008 server hosted by 1&1 which I would like to backup to my local desktop. What are some of the better alternatives to accomplish this? Daily automatic backups would be nice and a complete recovery would also be desired. …
Jim
0
votes
1 answer

MySQL - backup from binary data - some databases seems to be empty while they were not!

my OS died today, so I have to copy the data onto working machine. I've set up the new environment including MySQL, then copied contents of /var/lib/mysql from an old machine to the new one. Unfortunately, while looking at the results I have noticed…
migajek
  • 171
  • 2
  • 10
0
votes
2 answers

Virtual Machine Backups

Say I have a client that is running 2 VMWare virtual servers on the one box. Is there an easy way to backup the entire OS image so that if the hardware was to fail, the virtual OS could be put onto another box running the same VMWare software. Also,…
The Woo
  • 569
  • 6
  • 20
  • 39
0
votes
3 answers

Can i split/extract portion from .vmdk file for backup?

I've created VM with 30GB but my actual usage is just 8GB, i need to backup only 8GB out of whole 30GB of .vmdk. how can i do that?
stuartb4u
0
votes
1 answer

rdiff-backup command view backedup files

We are using rdiff-backup command to make incremental backups.My question is that how to view the files in a particular backup i.e, .gz file Also how to recover all the files in a particular gz file
Hulk
  • 371
  • 1
  • 6
  • 16
0
votes
2 answers

Correct procedure for preventing a spid from rolling back

Today I had a situation where I wanted to cancel an update to a table and several indexes and immediately restore back the database from a backup. I issued a kill command to kill the updating SPID. I then issued a kill with statusonly and there was…
SuperCoolMoss
  • 1,252
  • 11
  • 20
0
votes
3 answers

How to access SQL files from a BKS file?

I have a BKS file that is around 20GB. How do I extract the MSSQL files from that? Thanks
ServerDown
  • 362
  • 1
  • 2
  • 8
0
votes
1 answer

rdiff-backup command restore with date

If a backup was made using rdiff-backup command for some particular date what is the format that should be given to restore the files for that particular date. rdiff-bakup -r "dateformat" backup/a.txt /destination-dir Thanks..
Hulk
  • 371
  • 1
  • 6
  • 16
0
votes
1 answer

Restoring a DataBase

i have two deferent Servers databases connections , let say j and k .. and i have backup data file in j, i named it jtok.bak .. now , i am trying to restore a database in k from jtok.bak , the database name is kkk ... so ... is there a way to…
jjj
  • 125
  • 3
0
votes
1 answer

rdiff-backup command to restore

Let say i have a source directory which contains The contents /foo/a /foo/b(These are the files in a directory on a remote system) using rdiff command i make a backup as rdiff-backup root@192.168.254.111::/foo backups And a,b are now present in my…
Hulk
  • 371
  • 1
  • 6
  • 16
0
votes
2 answers

ANy software for auto backup of ubuntu system

I am using ubuntu 10.04. Now the ubuntu is performing as i want. Is there any thing like system restore in ubuntu. SO that if i upgrade the ubuntu softwares and it stops working and i can restore the system to previous state. thanks
John
0
votes
3 answers

How to backup a remote VPS machine?

I am considering opting for a VPS solution, with the server running Ubuntu server. I am pretty new to this, and I need to come up with a backup policy for my server data. Initial data is likely to be about 80Mb, and I expect the data to grow at…
user35402
  • 1,171
  • 3
  • 10
  • 18
0
votes
2 answers

SQL Server Backup modes, and a huge log file

Okay, I'm not a server administrator, a network guy, or a DBA. I'm merely a programmer helping out a small company. They have IT guy who isn't MS centric (most stuff is on Mac) and he and I are trying to figure out a solution here. We've got 1…
Matt Dawdy
  • 429
  • 1
  • 9
  • 19
1 2 3
…
22 23