Fixes Users of a newly restored database (SQL 2000)
-- fix Users set nocount on declare @v_dbuser varchar(255) declare @sql nvarchar(255) declare c1 cursor for select a.name from sysusers a, master..syslogins b where a.name = b.name open c1 fetch c1 into @v_dbuser while (@@FETCH_STATUS <> -1) BEGIN print 'Fixing User ' + @v_dbuser set @sql = 'sp_change_users_login ''auto_fix'',' + @v_dbuser exec sp_executesql @sql fetch c1 into @v_dbuser END CLOSE C1 DEALLOCATE C1
SQL Server 2012 introduces a new feature to issues backups on the Windows Azure Blob Storage service directly and restore from there when needed. But how does it work and how to get started using T-SQL commands for backup and restore operation?
2013-12-09
3,325 reads
One of the ongoing challenges of a DBA is to backup and restore databases. Backups are done on an automated schedule, but restores can take on many different versions, you may need to restore a production database, restore a development or test database or just create another copy of the database somewhere else. There are several ways of automating the restore process and creating a script, but this approach shows a way this can be done by just reading the contents of a directory for the backup files that exist.
2008-09-29
4,985 reads
Many DBA's have a Maintenance plan running that creates a backup every night and a transaction log backup every hour.Restoring them to another server (for whatever reason) can be a tedious job. That is why I wrote this T-SQL script.It will read the contents of a backup directory created by the maintenance plan and create […]
2004-06-25
906 reads
Not my script, but this script will transfer the logins to a new server or help you restore the in a DR situation with their correct passwords (encrypted).
2003-11-03
1,144 reads
This script was designed to restore a backup of a production database from disk file, handle multiple DB files, move the files to new location, with new database name that is customized for the date of the backup, create any missing logins, and fix any user accounts that are orphaned by differing SIDs from the […]
2003-04-24
1,063 reads
