SqlServer Command

login:

osql -S localhost -U sa -P xxxx

check sqlsever version:
select @@version
go

check collation name(characterset):

select name, collation_name from sys.databases

backup database:

BACKUP DATABASE DatabaseName TO DISK="D:\example\backupName.BAK" WITH INIT

GO

restore database:

SQLCMD -E -S LOCALHOST -Q "RESTORE DATABASE spotfire_server FROM DISK='C:\1\sp103.BAK' WITH REPLACE"

check all the databasename:

SELECT name, database_id, create_date FROM sys.databases ; GO

if execute through batch file: eg:

sqlcmd -i actionlog_refresh.sql > createview_log.txt

output the available hard disk volume size:

SELECT 
    volume_mount_point AS [Drive],
    total_bytes / 1024 / 1024 / 1024 AS [Total Size (GB)],
    available_bytes / 1024 / 1024 / 1024 AS [Available Space (GB)],
    (available_bytes * 1.0 / total_bytes) * 100 AS [Free Space %]
FROM sys.master_files AS f
CROSS APPLY sys.dm_os_volume_stats(f.database_id, f.file_id)
GROUP BY volume_mount_point, total_bytes, available_bytes
ORDER BY volume_mount_point;
GO