Layton ServiceDesk - Procedures - General - Sending your Database to Support
From Layton Support
(Difference between revisions)
(Added note on suggested file-naming convention) |
|||
| Line 6: | Line 6: | ||
#Back up the SQL database to a .bak file. Note the following settings:<br /><p>[[File:Lsd db backup01.png|link=]]<br /><br />[[File:Lsd db backup02.png|link=]]</p> | #Back up the SQL database to a .bak file. Note the following settings:<br /><p>[[File:Lsd db backup01.png|link=]]<br /><br />[[File:Lsd db backup02.png|link=]]</p> | ||
#Please indicate the '''version number''' of Layton ServiceDesk and the '''version of SQL Server''' you are using. It is suggested that you use this naming convention for the backup file:<p><code>lsd_VERSION_sqlVERSION_YEARMONTHDAY.bak</code></p>For example, if you were backing up a version 6.4.8.1 database running on SQL Server 2008 R2 on 29 April 2014, the resultant filename would be:<p><code>lsd_6481_sql2008r2_20140429.bak</code></p> | #Please indicate the '''version number''' of Layton ServiceDesk and the '''version of SQL Server''' you are using. It is suggested that you use this naming convention for the backup file:<p><code>lsd_VERSION_sqlVERSION_YEARMONTHDAY.bak</code></p>For example, if you were backing up a version 6.4.8.1 database running on SQL Server 2008 R2 on 29 April 2014, the resultant filename would be:<p><code>lsd_6481_sql2008r2_20140429.bak</code></p> | ||
| − | |||
#'''Important!''' You must zip the file before sending to greatly reduce its size. Send the .zip file to Support via our '''[http://laytontech.leapfile.net upload service]'''. | #'''Important!''' You must zip the file before sending to greatly reduce its size. Send the .zip file to Support via our '''[http://laytontech.leapfile.net upload service]'''. | ||
Revision as of 21:23, 20 August 2014
On occasion, Support may need to examine your database to understand the cause of an issue or to repair your database. Here are the instructions on how to send:
Please indicate which version of SQL Server you are using. Please also supply the password for the built-in admin account.
- Back up the SQL database to a .bak file. Note the following settings:
- Please indicate the version number of Layton ServiceDesk and the version of SQL Server you are using. It is suggested that you use this naming convention for the backup file:
For example, if you were backing up a version 6.4.8.1 database running on SQL Server 2008 R2 on 29 April 2014, the resultant filename would be:lsd_VERSION_sqlVERSION_YEARMONTHDAY.baklsd_6481_sql2008r2_20140429.bak - Important! You must zip the file before sending to greatly reduce its size. Send the .zip file to Support via our upload service.
