Tag Info

New answers tagged

0

Idiot solution 1 Restore entire database(s) on some temporary machine, then dump on the single database. Be sure to test the single database restores properly, can be issues with host/user permissions. Solution 2, I just wrote a script that does the single database dump restore. It fairly simple to do. I would send you the code but i wrote it centos which ...


0

Why are you trying to copy the secondary? Why can't you just use the backup from the primary to restore to your third location, that would make the most sense since this is obviously a copy of another database since you are restoring logs. I find it odd you'd have log backups and not access to a full backup. Having said that, if this is the only database on ...


2

You cannot use any backup statement to get a copy_only backup since the database is still restoring. At most the only option would be to use STANDBY mode but this would only provide you read access to all the data. You can get it to STANDBY by using the following command: RESTORE DATABASE sample_db WITH STANDBY = 'C:\Program Files\Microsoft SQL ...


0

A transaction log contains transaction details for many parallel both transactions that are (a) completed or (b) still processing. A transaction log backup is intended to harden the log file with all data needed to restore the database to the point in time that includes the last completed transaction. This also includes all the transactions still in ...


0

LastLSN + 1 of the Full database backup will fall in between the FirstLSN and LastLSN of its subsequent transaction log backup. (http://www.mssqltips.com/sqlservertip/3209/understanding-sql-server-log-sequence-numbers-for-backups/)


0

It came out that there was a stupid hack, unaccent function was marked immutable and there was an index that used this unaccent function. Dropping the index and recreating it after backup did the trick. Do not use hacks, folks :)


3

Your current method won't work, because it assumes that master was placed in the default data/log path, that it hasn't been moved at any point, and that the defaults haven't been changed since then. The registry approaches work, but they are kind of tedious (especially if you don't use the instance-specific XPs and have to provide the registry path ...


4

You won't want to use this method as the location of the master database files won't necessarily indicate the default location. I specify my master databases files to be on a separate drive, for example, while all the user databases are defaulted to another. You can use the following query from SQLandMe to find the default database locations: CREATE TABLE ...


5

Most SQL Servers are configured for the non-system databases to exist apart from the system databases. That is what is normally meant by the default path. You can lookup some code for finding this at: http://www.codeproject.com/Articles/684020/Checking-MS-SQL-Server-database-files-default-path Also, Alex Aza has provided a popular post over at ...



Top 50 recent answers are included