Tag Info

Hot answers tagged

3

I would suggest automating generation of the restore script. There are a few versions of this out there but Paul Brewer has a T-SQL and PowerShell version available. I have seen some setups as well that just include generating a restore script when the backup is accomplished. Which, just a note that a new open source backup solution was released by Sean ...


3

You can use sqlmigration - Start-SqlServerMigration.ps1 This script provides the ability to migrate databases using detach/copy/attach or backup/restore. SQL Server logins, including passwords, SID and database/server roles can also be migrated. In addition, job server objects can be migrated and server configuration settings can be exported or ...


2

I would suggest to use Restore Gene written by Paul Brewer. There is a T-SQL [sp_RestoreGene] and PowerShell version [ps_RestoreGene] of it and you can use it / customize it as per your needs. SQLServerCentral.com has an excellent article by the author on how to configure and describes the working of it as well - Restore Gene : Automating SQL Server ...


2

The above issue which you are facing is commonly known as the case for Orphan users: What commonly happens with SQL authenticated logins and database users on a restore is that the SIDS will be out of sync, thus breaking the relationship. This relationship must be repaired before you can connect to the database using that login, because in the eyes of SQL ...


1

maybe I'm a bit too "old school" but I've used a query and script for about 10 years now since the SQL Server 2005 days: SELECT LEFT(d.name,20) AS database_name, CONVERT(VARCHAR(16), MAX(CASE b.[type] WHEN 'D' THEN b.backup_finish_date END), 120) AS LastFullBackup, CONVERT(VARCHAR(16), MAX(CASE b.[type] WHEN 'I' THEN b.backup_finish_date END), 120) ...


1

USE mydb SET NOCOUNT on BEGIN TRY DROP table #S END TRY BEGIN CATCH END CATCH BEGIN TRY DROP TABLE #Mytable END TRY BEGIN CATCH END CATCH BEGIN TRY DROP TABLE #DBInfoResults END TRY BEGIN CATCH END CATCH go CREATE table #S ( server_name sysname, purpose VARCHAR(255), servertype VARCHAR(30) ) insert into #s VALUES ('myserver', 'Test', ...


1

Well I don't wonder about the restoring time. I wonder about your file amount. 15k files for 112MB? What the h...? Your symptom is nearly the same as during file copying. If you have two disc (disc1, disc2) and you try to copy 100.000 files each 4KB in size from disc1 to disc2 it may take hours. If you copy one zip file without compression (containing those ...



Only top voted, non community-wiki answers of a minimum length are eligible