Feed: Red Gate forums - AggScore: 49.0

Restore to point in time from 2 Full backups

---

Hi:

I have 2 full backups, and no log backups were performed between these copies. Is it possible to restore to a point in time between the 2 backups.

Here is what I have:
1) Full copy of 29/4/12 22:00
2) Full copy of 30/4/12 22:00 (no log backup was performed since point 1)
3) I want to restore to a point at 30/4/12 18:00

Is this possible? If so, what steps should I take to perform this?

Thanks,
Martin

Trial Version 7:Attaching to other servers to do restores...

---

Is the trail version of SQL Backup 7 able to connect to other servers when browsing the file system for backup files? I have large backup files (even with compression) on other servers that I need to use to restore those databases on yet another server.

Every time I try to attach to a server, it lets me, but when I navigate to the area I need to use a backup file from, I get errors making it seem like the file is not there.

Any thoughts would be most appreciated.

RE: SQL Compare command line and /migrationfolder switch

---

freecell1 wrote:

Here are the property values from my local box (linked to svn) and the dev server we push to: Local: http://tco-dev-scm.xxx.internal/svn/code/trunk/Database/MigrationScripts/Intranet/ Dev: http://tco-dev-scm.xxx.internal/svn/code/trunk/Database/MigrationScripts/Intranet/ They seem the same. Is it possible the way I call the command line, or the exclude filters, is causing a problem? Here are the command line params: /exclude:role /exclude:user /exclude:assembly /sourcecontrol1 /Server2:TCO-DEV-SQL-02 /Database2:Intranet /sync /migrationfolder:C:TeamCitybuildAgentwork946b3977434c5179databasemigrationscriptsIntranet /scriptsfolderxml:C:TeamCitybuildAgentwork946b3977434c5179BuildSharedconfigSQLCompareSvnConfig_Intranet_temp.xml /revision1:HEAD /versionusername1:builduser /versionpassword1:xxx Thanks, John

Can you experimentally try putting an explicity revision after /revision1: instead of HEAD to see if that's causing issues?

RE: SQL Compare command line and /migrationfolder switch

---

jhoerr wrote:

Ah, ok -- and that's the piece that can be supplied via the /scriptsfolderxml argument, correct? This is making sense now. We follow a pretty traditional trunk/feature branch pattern and release from tags, so being able to dynamically provide that repository URL is helpful.

I'm thinking that we should ideally expose the repo using a command line switch rather than relying on the xml file. I take it that the xml file isn't ideal for you?

RE: 'Non-schema statement was ignored' warnings

---

I get this warning as well. It happens on procs and on some .sql files we have in the "data" folder (putting data under source control) and don't understand what is causing it or how to resolve it. Please help.

RE: Cannot Delete Backup File

---

I also have a related issue.
it appears for larger virtual DBs, when I restore over a previous one, hyperbak will only release it's hold after a restart of the entire server.
--for example: test_virtual then replace Test_virtual by either deleting or restoring with replace.

if I stop hyperbak, stop sql, restart hyperbak, restart sql around 50% of the time it will fail to recover the DB, or mark it as suspect. but a reboot doesn't have that issue.

Is there a way to make hyperbak give up its hold on files manually?

RE: How do you reset authentication from SQL back to Windows?

---

That was it! Thank you again Marianne for your support, and my apologies that I didn't read that more closely in the original thread. I have things back and operational again.

Have a great weekend...

RE: SQL 2012 SSMS crashes

---

I'm not anxious to back off to the previous version, so what can I do to stop the error message at startup of SSMS? I'm using Microsoft SQL Server Management Studio 10.50.1600.1; connecting to 2005, 2008 and 2008R2 servers.

RE: SQL Compare command line and /migrationfolder switch

---

Here are the property values from my local box (linked to svn) and the dev server we push to:

Local:



http://tco-dev-scm.xxx.internal/svn/code/trunk/Database/MigrationScripts/Intranet/


Dev:

http://tco-dev-scm.xxx.internal/svn/code/trunk/Database/MigrationScripts/Intranet/

They seem the same. Is it possible the way I call the command line, or the exclude filters, is causing a problem? Here are the command line params:

/exclude:role /exclude:user /exclude:assembly /sourcecontrol1 /Server2:TCO-DEV-SQL-02 /Database2:Intranet /sync /migrationfolder:C:TeamCitybuildAgentwork946b3977434c5179databasemigrationscriptsIntranet /scriptsfolderxml:C:TeamCitybuildAgentwork946b3977434c5179BuildSharedconfigSQLCompareSvnConfig_Intranet_temp.xml /revision1:HEAD /versionusername1:builduser /versionpassword1:xxx

Thanks,

John

RE: Code on stack

---

Thanks for your post.

Based on the information supplied I'm afraid we can't possibly make any suggestion - we don't know anything about your application and we've not seen the results from your profiling.

I'm happy to take a look at your profiling results, if you can zip them up and email them to support@red-gate.com quoting F0060481 in the subject line. Once we see the results, we may be able to make some suggestions of where you should look.