Creating an archive using tar command

Creating an uncompressed tar archive using option cvf This is the basic command to create a tar archive.

$ tar cvf archive_name.tar dirname/

In the above command:
c – create a new archive
v – verbosely list files which are processed.
f – following is the archive file name

Creating a tar gzipped archive using option cvzf The above tar cvf option, does not provide any compression. To use a gzip compression on the tar archive, use the z option as shown below.

$ tar cvzf archive_name.tar.gz dirname/

z – filter the archive through gzip

Перемещение базы данных tempdb

1. Определение логических имен файлов базы данных tempdb и их текущего местоположения на диске.

   SELECT name, physical_name AS CurrentLocation
   FROM sys.master_files
   WHERE database_id = DB_ID(N'tempdb');
   GO

2. Измените местоположение каждого файла с помощью ALTER DATABASE.

   USE master;
   GO
   ALTER DATABASE tempdb 
   MODIFY FILE (NAME = tempdev, FILENAME = 'E:\SQLData\tempdb.mdf');
   GO
   ALTER DATABASE tempdb 
   MODIFY FILE (NAME = templog, FILENAME = 'F:\SQLLog\templog.ldf');
   GO

3. Остановите и перезапустите экземпляр SQL Server.
4. Проверьте изменение файла.

   SELECT name, physical_name AS CurrentLocation, state_desc
   FROM sys.master_files
   WHERE database_id = DB_ID(N'tempdb');

5. Удалите файлы tempdb.mdf и templog.ldf из исходного местоположения.

MSDN_LINK