Hot answers tagged

7

Once you have restored the database on another system, you can detach the database, move/copy all DB files (data and log) to your target system and attach the database there. The method is relatively simple in most circumstances, you can follow this Microsoft doc for commands and this concept doc for more detail. Databases will usually grow over time, you ...


3

At least 2 approaches: Put the backup on a shared folder, make the SQL server restore from the shared folder. The MS SQL server accepts shared folder syntax (\server\share\file.bak) pretty well. It will not copy the database locally, it will read it from the shared drive. Depending on your shared folder permissions, this may require logging in as the SQL ...


3

After contacting Microsoft we come to know that we have encountered a rare situation which was blocking us with the restore on SQL Server 2019. To resolve this we had to share our backups with Microsoft to fix and they had to disable an assertion check on it manually. (weird, but the only solution) Good news is the hotfix is going to roll out soon. Version ...


2

External Drives to the Rescue I had a similar situation (needed hard drive upgrade on a server with most of the space taken by an active database) years ago with a server in a data center (long story...) and the solution was to buy an external hard drive (via the data center, so it cost a bit extra) and use that to store the backups, do the upgrade and then ...


2

As @AndrewSayer said, it has nothing to do with your dmp file. In order to connect to a database, the client (in your case, 'imp' utility) has to be able to locate the database. This means knowing the server the database is on, the port the database listener is uing, and the service name by which the listener knows the database. This information is ...


2

Using rsync is fine as long as the database were shut down at the time, which apparently was not the case here. But what were you doing while the rsync was running? Did you start the rsync when the cluster was empty, and then run it very slowly (low --bwlimit) while you also restored large dump files into the system? The amount of corruption you are seeing ...


1

screen screen is like 'open me a virtual terminal that I can detach from, then re-attach to later'. You use it for long-running processes when you want to disconnect from the box. You start a screen by entering the command screen (and press enter to clear the first message). Now you are in a new session. Run what you like. You can & it if you like, but I ...


1

Reference: log_shipping_monitor_secondary (Transact-SQL) sp_help_log_shipping_monitor (Transact-SQL) Monitor Transaction Log shipping using T-SQL and SSMS by Jignesh Raiyani View the Log Shipping Report (SQL Server Management Studio) Using TSQL get details of last restored transaction log Backup (Subscriber Side): SELECT b.type, b.first_lsn, b.last_lsn, b....


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