SQL Server 清空日志文件，查询密码

执行指定sql文件并记录

sqlcmd -S . -U mysql -P 123123 -i C:\mysql.sql -o C:\jilu.txt

清空数据库中ldf日志文件

/****************************************
 * 将my2022  替换为您要操作的数据库即可
 ****************************************/
USE [master]
ALTER DATABASE [my2022] 
SET RECOVERY SIMPLE WITH NO_WAIT
ALTER DATABASE [my2022] 
SET RECOVERY SIMPLE
GO
USE [my2022]
DECLARE @logname VARCHAR(150)
SELECT @logname = NAME
FROM   sys.database_files
WHERE  NAME LIKE'%log'
DBCC SHRINKFILE(@logname, 11, TRUNCATEONLY)
GO
USE [master]
ALTER DATABASE [my2022]
SET RECOVERY FULL WITH NO_WAIT
ALTER DATABASE [my2022] 
SET RECOVERY FULL
GO

权限修复

Use [my2022]
go
sp_change_users_login 'update_one', 'my2022', 'my2022'

SQL查询密码

SELECT name, LOGINPROPERTY(name, 'PasswordHash' ) hash
FROM syslogins
WHERE password IS NOT NULL
ORDER BY name

新建用户

CREATE LOGIN sa WITH PASSWORD = 加密字符串 HASHED