akc on the server
satya - Fri May 11 2012 16:41:04 GMT-0400 (Eastern Daylight Time)
d:\host\c04\satya: main directory
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
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
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
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
Current server is at: 25.42.205.120
satya - 1/20/2015, 3:54:51 PM
Search for hamachi password: Logmein simple1_LL
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
backups are at: D:\host\c04\satya\backup
satya - 1/20/2015, 4:36:26 PM
The main directory is akc-sqlserver
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
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