Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rohan
You last visited: Today at 14:56

  • Please register to post and access all features, it's quick, easy and FREE!

 

Saving DB's

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Feb 2014
Posts: 319
Received Thanks: 75
Saving DB's

I need to format and dont want to lose my db's and all.
I recall having to restore them when I began this whole process but Im not sure how to save them properly so once I finish the format and install I can just restore them and have them as they are currently.



IncognitoOne is offline  
Old   #2

 
elite*gold: 33
The Black Market: 100/0/2
Join Date: Jan 2011
Posts: 2,693
Received Thanks: 454
Quote:
Originally Posted by IncognitoOne View Post
I need to format and dont want to lose my db's and all.
I recall having to restore them when I began this whole process but Im not sure how to save them properly so once I finish the format and install I can just restore them and have them as they are currently.
I can help you tomorrow if im back Home if you want.
Also can show you Step for Step how you can save a DB ^^

If you make it asap here:



Dr.Dr.SheldonLeeCooper is offline  
Old   #3
 
elite*gold: 0
Join Date: Jul 2014
Posts: 278
Received Thanks: 50
Simply back up each one you want to save using SQL Server Management Studio.

You must register and activate your account in order to view images.

By default the tool plops the backups here:

C:\Program Files\Microsoft SQL Server\<DB INSTANCE NAME>\MSSQL\Backup
C:\Program Files (x86)\Microsoft SQL Server\<DB INSTANCE NAME>\MSSQL\Backup
(depends on if you installed 64-bit or 32-bit sql server)

Copy them out to someplace safe.

When you've reinstalled Windows and MSSQL Server, restore each database using SQL Server Management Studio. This part is niggly and unnecessarily tedious (thanks Microsoft).

But at the end of the day you will have your databases just as you left them before reformatting.
Banana Bandit is offline  
Old   #4
 
elite*gold: 0
Join Date: Feb 2014
Posts: 319
Received Thanks: 75
Thanks Joe thats exactly what I want to do and Rito if I have any issues I'll harass you , you know that :P

Now to finish this stupid iso image
IncognitoOne is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
Legion not saving
I am currently working on a non release of an older DB I am using phdev... I can not get my legions to save to the cq_user sindicate_id spot and can...
1 Replies - EO PServer Hosting
hot keys not saving
i have a private server im working on (rapplez 8.1) and i can not seem to get the in game hot keys to save (every time i log in i have to reset them...
22 Replies - Rappelz Private Server
saving
When im changing the status of a player ex. normal to PM. Then they only got it untill they logoff. But how can I save it? I tried alot things...
10 Replies - CO2 PServer - Discussions / Questions
help saving
for some reason when i set my compose rate high just to mess around everytime i logg off it drops alot of the stars i just got off ... any1 know what...
4 Replies - EO PServer Hosting
Saving with CE/UCE
Hey guys. Revo 8.3 and rootkit is fine for International Servers. Question: Could i change the cooldown values (eg splashy, ice magic etc...)...
1 Replies - Kal Online



All times are GMT +2. The time now is 14:56.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.