Tips and tricks

hmtoggle_plus1Hur ändrar man språk?
hmtoggle_plus1Hur får man reda på vad en variabel betyder?

Läs om detta under avsnittet Variabler.

 

hmtoggle_plus1Hur får man reda på vad en inställning i en kontrolltabell betyder?

Om man väljer en inställningsparameter i en kontrolltabell visas en hjälptext i fönstret nedanför:

 

Kontrolltabell_hjalptext

 

Det finns också förklaringar av kontrolltabeller på Heurekas WIki, liksom det kommer att beskrivas mer utförligt i denna hjälp allt eftersom.

 

hmtoggle_plus1Mina simuleringar listas inte längre under resultat

Prova att klicka på "Test Connection" där du väljer resultatdatabas (under projektfliken):

 

TestConnection

 

 

hmtoggle_plus0 SQL Server data administration to free disk space

Use SQL Server Managment Studio to either backup files, or detach and reattach the database files efter moving them to the external disk. Use backup if you just want to store the files and do not intend to use them for a while, or detach/attach if you want to use the databas files directly after moving them. In addition, you can change the default database path to the desired disk, so that new databases are stored at the desired location automatically. However, the performance (time for reading and writing data to the database), is typically much poorer on an external disk than on an internal.

 

These are the main steps to move the database files with detach/attach. The steps may vary slighty depending on what version of SQL Server you are running:

1. Start SQL Server Managment Studio (SMSS), via the Start-button, and right-click SMSS and choose Run as administrator.

2. Under Databases, right click the desired database and choose Properties.

3. Under Files, note where the database files are located (the mdf-file and the log-file).

4. Click Cancel

5. Right-click the database again, and select Tasks > Detach.

6. When the detach operation is completed, move the database files (mdf and log) to the desired location.

7. In SMSS, reattach the database files by right-clicking Databases and choose Attach according to instructions you can find on several places on the internet, for example here: https://www.mssqltips.com/sqlservertip/6222/sql-server-attach-and-detach-database-examples/

 

To make a backup:

1. Same as step 1 above.

2. Right-click the database to backup of and select Tasks > Back Up... See futher instructions here: Create a Full Database Backup - SQL Server | Microsoft Docs

3. When the backup-process is completed, you can deleted the database, by selecting it and press Delete.

Contact support. © Sveriges Lantbruksuniversitet