satya - Fri May 11 2012 16:41:04 GMT-0400 (Eastern Daylight Time)

d:\host\c04\satya: main directory

satya - Fri May 11 2012 16:42:46 GMT-0400 (Eastern Daylight Time)

Under this directory I have


akc
akc-sqlserver
eclipse workspace
downloads

satya - Fri May 11 2012 16:45:36 GMT-0400 (Eastern Daylight Time)

root\backup has what?


release process
old releases staged
new releases staged
tomcat configuration files

satya - Fri May 11 2012 16:46:19 GMT-0400 (Eastern Daylight Time)

where is my jdk?


d:\apps\jdk6_64

satya - Fri May 11 2012 16:46:54 GMT-0400 (Eastern Daylight Time)

where is my eclipse


d:\apps\eclipse_helios_64

satya - Fri May 11 2012 16:47:43 GMT-0400 (Eastern Daylight Time)

where is my tomcat


d:\apps\tomcat6_64

satya - Fri May 11 2012 16:48:13 GMT-0400 (Eastern Daylight Time)

Tomcat service name


Apache Tomcat 6

satya - Fri May 11 2012 16:49:40 GMT-0400 (Eastern Daylight Time)

tomcat executable


D:\apps\tomcat6_64\bin\tomcat6.exe //RS//Tomcat6

So we are using tomcat6_64 directory. Under this directory we will have the conf directory that tells us a lot about which "akc" I am using.

satya - Fri May 11 2012 16:58:05 GMT-0400 (Eastern Daylight Time)

the current akc directory is: d:\host\c04\satya\akc-sqlserver

satya - Sat May 12 2012 12:32:42 GMT-0400 (Eastern Daylight Time)

where are my sqlserver backups on the server?


root\backup\sql-server

satya - Sat May 12 2012 12:43:42 GMT-0400 (Eastern Daylight Time)

what is the userid/password for the database


SatyaDBUser
(search gmail with that key word)

satya - Sat May 12 2012 12:45:33 GMT-0400 (Eastern Daylight Time)

Here are my production server settings


Database.name = akcSqlServerReportsDB
Database.akcSqlServerReportsDB.jdbc_driver=com.microsoft.sqlserver.jdbc.SQLServerDriver
Database.akcSqlServerReportsDB.connection_string =jdbc:sqlserver://JDSERVER\\JDSQL2008;database=akc_prod
Database.akcSqlServerReportsDB.userid=SatyaDBUser
Database.akcSqlServerReportsDB.password=non-disclosed
Database.akcSqlServerReportsDB.expirationTimeInMin=5
Database.akcSqlServerReportsDB.minimumNumberOfConnections=5

satya - Sat May 12 2012 12:46:06 GMT-0400 (Eastern Daylight Time)

Key elements


database: akc_prod
user: SatyaDBUser

satya - Sat May 12 2012 12:59:09 GMT-0400 (Eastern Daylight Time)

Here is where it is backed up


D:\host\c04\satya\backup\sql-server\database-only\May-15-2012

satya - Sat May 12 2012 12:59:46 GMT-0400 (Eastern Daylight Time)

here are notes on backing up a sql server database

satya - Sat May 12 2012 13:16:56 GMT-0400 (Eastern Daylight Time)

Current akc is running the aspire build


aspire_jsdk23_b31_logset_6_030212.jar

satya - Sat May 12 2012 13:17:14 GMT-0400 (Eastern Daylight Time)

There will be a new one for the lists release

satya - 6/1/2013 8:39:41 AM

Revisit and update the backup process on this server


this should include

1. database backup
2. akc backup

satya - 6/1/2013 8:54:30 AM

take a look at this directory for incremental backups


G:\satya-bkp\bydate\nov-22-2012

satya - 7/3/2013 3:54:31 PM

How to backsup sql server on jdserver


start/sql server mgmt studio
userid/password
akc_prod
right-click
tasks
backup database
backup type:full
backup to: disk
name: example: akc_prod_jul_01_2013

The backup file needs to be like:

D:\host\c04\satya\backup\sql-server\database-only\Jul-01-2013\akc-prod-copy-only-jul-01-2013

The complete filename not the directory!!

satya - 7/3/2013 4:39:13 PM

it has to be the full file name minus the extension

satya - 1/20/2015, 2:43:58 PM

Logging into the server

Search in gmail for JDServer, Hamachi, PassSat, PassSat07$, PassSat11$

satya - 1/20/2015, 2:45:36 PM

More search keys


Latest "jdserver" passwords:

satya - 1/20/2015, 2:50:32 PM

Current server is at: 25.42.205.120

satya - 1/20/2015, 3:54:51 PM

Search for hamachi password: Logmein simple1_LL

satya - 1/20/2015, 4:22:20 PM

Once I login


Satya Desktop
Satya shortcut

satya - 1/20/2015, 4:23:53 PM

backups are at: D:\host\c04\satya\backup

satya - 1/20/2015, 4:36:26 PM

The main directory is akc-sqlserver

satya - 1/20/2015, 5:00:16 PM

Databases are backed up to: D:\host\c04\satya\backup\sql-server\database-only

satya - 1/20/2015, 5:01:36 PM

Here

There are dated directories

Look for the latest

(In the future, copy a readme.txt file here)

satya - 1/20/2015, 5:05:01 PM

Likely sequence for database backup


Take a backup as one takes sql server backups
Copy the final file to the dated directory above
Put a readme.txt as to what the backup is
Go to google drive

Go here: 
********
C:\Users\Satya\Google Drive\emergency-server-bkpdatabase-backups\akc-sqlserver-database-backup

Use show_new_files.cmd
Use copy_new_files.cmd

You will see the new directory copied to

C:\Users\Satya\Google Drive\emergency-server-bkpdatabase-backups\akc-sqlserver-database-backupakc-sqlserver-database-backup