Se Val av språk
|
Läs om detta under avsnittet Variabler.
|
Om man väljer en inställningsparameter i en kontrolltabell visas en hjälptext i fönstret nedanför:
Det finns också förklaringar av kontrolltabeller på Heurekas WIki, liksom det kommer att beskrivas mer utförligt i denna hjälp allt eftersom.
|
Prova att klicka på "Test Connection" där du väljer resultatdatabas (under projektfliken):
|
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. |