Blog Archives

How to overwrite SQL Server Backup rather than Append Mediaset

T SQL Date format convert function

In this post I will show you how to overwrite sql server backup file rather than append (default action is append to backup media set) If you try below t-sql command to take full sql server database backup then you

Tagged with: , ,
Posted in DBA, SQL Server, T-SQL Tips

How to login to sql server after all admin accounts removed and you are locked

T SQL Date format convert function

Recently I had an interesting situation. Consider below situation You want to connect to sql server as sysadmin but you are not added to sql server logins using windows authentication BUILTIN\Administrators group has been removed from SQL Server You have

Tagged with: ,
Posted in DBA, SQL Server