Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlserverdba
Yak Posting Veteran
53 Posts |
 Posted - 2009-07-22 : 19:04:46
|
| Hi,I'm planning to upgrade DB and applications. I want to flush database before start FULL backup. Is there any way I can forecely switch logs and then start backup?Thanks, |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-22 : 21:44:59
|
| what recovery model is your database in?if full, take a full backup, then a tran log backup.if simple, well, nope, best you can do is get the users out first. |
 |
|
|
|
|
|
Log switch before migration