Where Does sqlpackage.exe Store Database Backups? The Next CEO of Stack OverflowBizTalk 2009...
Why am I getting "Static method cannot be referenced from a non static context: String String.valueOf(Object)"?
(How) Could a medieval fantasy world survive a magic-induced "nuclear winter"?
Getting Stale Gas Out of a Gas Tank w/out Dropping the Tank
Can you teleport closer to a creature you are Frightened of?
How to get the last not-null value in an ordered column of a huge table?
How do I fit a non linear curve?
"Eavesdropping" vs "Listen in on"
Calculate the Mean mean of two numbers
Aggressive Under-Indexing and no data for missing index
Man transported from Alternate World into ours by a Neutrino Detector
If Nick Fury and Coulson already knew about aliens (Kree and Skrull) why did they wait until Thor's appearance to start making weapons?
Is it ever safe to open a suspicious HTML file (e.g. email attachment)?
Help! I cannot understand this game’s notations!
Raspberry pi 3 B with Ubuntu 18.04 server arm64: what chip
Lucky Feat: How can "more than one creature spend a luck point to influence the outcome of a roll"?
Is there a difference between "Fahrstuhl" and "Aufzug"?
Film where the government was corrupt with aliens, people sent to kill aliens are given rigged visors not showing the right aliens
Traveling with my 5 year old daughter (as the father) without the mother from Germany to Mexico
What was Carter Burke's job for "the company" in Aliens?
From jafe to El-Guest
What connection does MS Office have to Netscape Navigator?
Can this note be analyzed as a non-chord tone?
IC has pull-down resistors on SMBus lines?
Why is information "lost" when it got into a black hole?
Where Does sqlpackage.exe Store Database Backups?
The Next CEO of Stack OverflowBizTalk 2009 Visual Studio 2008 Deployment errorSql Server 2008 Backups not quite runningSQL Server “Quick” Incremental backup?SQL Server log backups “stalling”Need help recovering a corrupt SQL databaseCreating a clone of a SQL Server database via backup/restoreSQL Server Backup File Significantly Smaller After Table RecreationCreating database backups using SQL Server 2012 Tools that can be imported by SQL Server 2008 R2Can I restore a SQL Server instance from file backups only?Where does DPM use space on a protected SQL Server?
I have a deployment script which uses sqlpackage.exe to deploy incremental changes to a database. (The project is maintained in the database edition of Visual Studio 2012 Express.) One of the flags I'm passing to this tool is:
/p:BackupDatabaseBeforeChanges=True
What I'm not finding, however, is where these backups exist. So far every piece of documentation I find on MSDN simply says:
Get or set boolean that specifies whether a database backup will be
performed before proceeding with the actual deployment actions.
Are the backups only temporary and simply deleted after a successful deployment? Or, worse, is it simply not creating backups at all despite this flag? If it is creating backups, where are they? I've looked in:
C:Program FilesMicrosoft SQL ServerMSSQL11.SQLEXPRESS2012MSSQLBackup
But there's nothing there. Maybe the "backup" is in a different form somewhere? Essentially what I'd like to do is indefinitely retain a snapshot of the target database before any given deployment (basically what I do with the deployed application in the same script).
sql-server sql-server-2012 deployment
bumped to the homepage by Community♦ 8 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have a deployment script which uses sqlpackage.exe to deploy incremental changes to a database. (The project is maintained in the database edition of Visual Studio 2012 Express.) One of the flags I'm passing to this tool is:
/p:BackupDatabaseBeforeChanges=True
What I'm not finding, however, is where these backups exist. So far every piece of documentation I find on MSDN simply says:
Get or set boolean that specifies whether a database backup will be
performed before proceeding with the actual deployment actions.
Are the backups only temporary and simply deleted after a successful deployment? Or, worse, is it simply not creating backups at all despite this flag? If it is creating backups, where are they? I've looked in:
C:Program FilesMicrosoft SQL ServerMSSQL11.SQLEXPRESS2012MSSQLBackup
But there's nothing there. Maybe the "backup" is in a different form somewhere? Essentially what I'd like to do is indefinitely retain a snapshot of the target database before any given deployment (basically what I do with the deployed application in the same script).
sql-server sql-server-2012 deployment
bumped to the homepage by Community♦ 8 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
I have a deployment script which uses sqlpackage.exe to deploy incremental changes to a database. (The project is maintained in the database edition of Visual Studio 2012 Express.) One of the flags I'm passing to this tool is:
/p:BackupDatabaseBeforeChanges=True
What I'm not finding, however, is where these backups exist. So far every piece of documentation I find on MSDN simply says:
Get or set boolean that specifies whether a database backup will be
performed before proceeding with the actual deployment actions.
Are the backups only temporary and simply deleted after a successful deployment? Or, worse, is it simply not creating backups at all despite this flag? If it is creating backups, where are they? I've looked in:
C:Program FilesMicrosoft SQL ServerMSSQL11.SQLEXPRESS2012MSSQLBackup
But there's nothing there. Maybe the "backup" is in a different form somewhere? Essentially what I'd like to do is indefinitely retain a snapshot of the target database before any given deployment (basically what I do with the deployed application in the same script).
sql-server sql-server-2012 deployment
I have a deployment script which uses sqlpackage.exe to deploy incremental changes to a database. (The project is maintained in the database edition of Visual Studio 2012 Express.) One of the flags I'm passing to this tool is:
/p:BackupDatabaseBeforeChanges=True
What I'm not finding, however, is where these backups exist. So far every piece of documentation I find on MSDN simply says:
Get or set boolean that specifies whether a database backup will be
performed before proceeding with the actual deployment actions.
Are the backups only temporary and simply deleted after a successful deployment? Or, worse, is it simply not creating backups at all despite this flag? If it is creating backups, where are they? I've looked in:
C:Program FilesMicrosoft SQL ServerMSSQL11.SQLEXPRESS2012MSSQLBackup
But there's nothing there. Maybe the "backup" is in a different form somewhere? Essentially what I'd like to do is indefinitely retain a snapshot of the target database before any given deployment (basically what I do with the deployed application in the same script).
sql-server sql-server-2012 deployment
sql-server sql-server-2012 deployment
asked Jun 18 '13 at 17:25
DavidDavid
1186
1186
bumped to the homepage by Community♦ 8 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
bumped to the homepage by Community♦ 8 mins ago
This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Have a look at the .sql script that the deploy is creating. It should contain something like
IF (DB_ID(N'$(DatabaseName)') IS NOT NULL)
BEGIN
DECLARE @rc int, -- return code
@fn nvarchar(4000), -- file name for back up
@dir nvarchar(4000) -- backup directory
EXEC @rc = [master].[dbo].[xp_instance_regread] N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerMSSQLServer', N'BackupDirectory', @dir output, 'no_output'
if (@rc = 0) SELECT @dir = @dir + N''
IF (@dir IS NULL)
BEGIN
EXEC @rc = [master].[dbo].[xp_instance_regread] N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerMSSQLServer', N'DefaultData', @dir output, 'no_output'
if (@rc = 0) SELECT @dir = @dir + N''
END
IF (@dir IS NULL)
BEGIN
EXEC @rc = [master].[dbo].[xp_instance_regread] N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerSetup', N'SQLDataRoot', @dir output, 'no_output'
if (@rc = 0) SELECT @dir = @dir + N'Backup'
END
IF (@dir IS NULL)
BEGIN
SELECT @dir = N'$(DefaultDataPath)'
END
SELECT @fn = @dir + N'$(DatabaseName)' + N'-' +
CONVERT(nchar(8), GETDATE(), 112) + N'-' +
RIGHT(N'0' + RTRIM(CONVERT(nchar(2), DATEPART(hh, GETDATE()))), 2) +
RIGHT(N'0' + RTRIM(CONVERT(nchar(2), DATEPART(mi, getdate()))), 2) +
RIGHT(N'0' + RTRIM(CONVERT(nchar(2), DATEPART(ss, getdate()))), 2) +
N'.bak'
BACKUP DATABASE [$(DatabaseName)] TO DISK = @fn
END
GO
As you can see above, the destination for the backups is determined by the registry values which store the default backup location for the target SQL Server.
add a comment |
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "2"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f516708%2fwhere-does-sqlpackage-exe-store-database-backups%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Have a look at the .sql script that the deploy is creating. It should contain something like
IF (DB_ID(N'$(DatabaseName)') IS NOT NULL)
BEGIN
DECLARE @rc int, -- return code
@fn nvarchar(4000), -- file name for back up
@dir nvarchar(4000) -- backup directory
EXEC @rc = [master].[dbo].[xp_instance_regread] N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerMSSQLServer', N'BackupDirectory', @dir output, 'no_output'
if (@rc = 0) SELECT @dir = @dir + N''
IF (@dir IS NULL)
BEGIN
EXEC @rc = [master].[dbo].[xp_instance_regread] N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerMSSQLServer', N'DefaultData', @dir output, 'no_output'
if (@rc = 0) SELECT @dir = @dir + N''
END
IF (@dir IS NULL)
BEGIN
EXEC @rc = [master].[dbo].[xp_instance_regread] N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerSetup', N'SQLDataRoot', @dir output, 'no_output'
if (@rc = 0) SELECT @dir = @dir + N'Backup'
END
IF (@dir IS NULL)
BEGIN
SELECT @dir = N'$(DefaultDataPath)'
END
SELECT @fn = @dir + N'$(DatabaseName)' + N'-' +
CONVERT(nchar(8), GETDATE(), 112) + N'-' +
RIGHT(N'0' + RTRIM(CONVERT(nchar(2), DATEPART(hh, GETDATE()))), 2) +
RIGHT(N'0' + RTRIM(CONVERT(nchar(2), DATEPART(mi, getdate()))), 2) +
RIGHT(N'0' + RTRIM(CONVERT(nchar(2), DATEPART(ss, getdate()))), 2) +
N'.bak'
BACKUP DATABASE [$(DatabaseName)] TO DISK = @fn
END
GO
As you can see above, the destination for the backups is determined by the registry values which store the default backup location for the target SQL Server.
add a comment |
Have a look at the .sql script that the deploy is creating. It should contain something like
IF (DB_ID(N'$(DatabaseName)') IS NOT NULL)
BEGIN
DECLARE @rc int, -- return code
@fn nvarchar(4000), -- file name for back up
@dir nvarchar(4000) -- backup directory
EXEC @rc = [master].[dbo].[xp_instance_regread] N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerMSSQLServer', N'BackupDirectory', @dir output, 'no_output'
if (@rc = 0) SELECT @dir = @dir + N''
IF (@dir IS NULL)
BEGIN
EXEC @rc = [master].[dbo].[xp_instance_regread] N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerMSSQLServer', N'DefaultData', @dir output, 'no_output'
if (@rc = 0) SELECT @dir = @dir + N''
END
IF (@dir IS NULL)
BEGIN
EXEC @rc = [master].[dbo].[xp_instance_regread] N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerSetup', N'SQLDataRoot', @dir output, 'no_output'
if (@rc = 0) SELECT @dir = @dir + N'Backup'
END
IF (@dir IS NULL)
BEGIN
SELECT @dir = N'$(DefaultDataPath)'
END
SELECT @fn = @dir + N'$(DatabaseName)' + N'-' +
CONVERT(nchar(8), GETDATE(), 112) + N'-' +
RIGHT(N'0' + RTRIM(CONVERT(nchar(2), DATEPART(hh, GETDATE()))), 2) +
RIGHT(N'0' + RTRIM(CONVERT(nchar(2), DATEPART(mi, getdate()))), 2) +
RIGHT(N'0' + RTRIM(CONVERT(nchar(2), DATEPART(ss, getdate()))), 2) +
N'.bak'
BACKUP DATABASE [$(DatabaseName)] TO DISK = @fn
END
GO
As you can see above, the destination for the backups is determined by the registry values which store the default backup location for the target SQL Server.
add a comment |
Have a look at the .sql script that the deploy is creating. It should contain something like
IF (DB_ID(N'$(DatabaseName)') IS NOT NULL)
BEGIN
DECLARE @rc int, -- return code
@fn nvarchar(4000), -- file name for back up
@dir nvarchar(4000) -- backup directory
EXEC @rc = [master].[dbo].[xp_instance_regread] N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerMSSQLServer', N'BackupDirectory', @dir output, 'no_output'
if (@rc = 0) SELECT @dir = @dir + N''
IF (@dir IS NULL)
BEGIN
EXEC @rc = [master].[dbo].[xp_instance_regread] N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerMSSQLServer', N'DefaultData', @dir output, 'no_output'
if (@rc = 0) SELECT @dir = @dir + N''
END
IF (@dir IS NULL)
BEGIN
EXEC @rc = [master].[dbo].[xp_instance_regread] N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerSetup', N'SQLDataRoot', @dir output, 'no_output'
if (@rc = 0) SELECT @dir = @dir + N'Backup'
END
IF (@dir IS NULL)
BEGIN
SELECT @dir = N'$(DefaultDataPath)'
END
SELECT @fn = @dir + N'$(DatabaseName)' + N'-' +
CONVERT(nchar(8), GETDATE(), 112) + N'-' +
RIGHT(N'0' + RTRIM(CONVERT(nchar(2), DATEPART(hh, GETDATE()))), 2) +
RIGHT(N'0' + RTRIM(CONVERT(nchar(2), DATEPART(mi, getdate()))), 2) +
RIGHT(N'0' + RTRIM(CONVERT(nchar(2), DATEPART(ss, getdate()))), 2) +
N'.bak'
BACKUP DATABASE [$(DatabaseName)] TO DISK = @fn
END
GO
As you can see above, the destination for the backups is determined by the registry values which store the default backup location for the target SQL Server.
Have a look at the .sql script that the deploy is creating. It should contain something like
IF (DB_ID(N'$(DatabaseName)') IS NOT NULL)
BEGIN
DECLARE @rc int, -- return code
@fn nvarchar(4000), -- file name for back up
@dir nvarchar(4000) -- backup directory
EXEC @rc = [master].[dbo].[xp_instance_regread] N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerMSSQLServer', N'BackupDirectory', @dir output, 'no_output'
if (@rc = 0) SELECT @dir = @dir + N''
IF (@dir IS NULL)
BEGIN
EXEC @rc = [master].[dbo].[xp_instance_regread] N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerMSSQLServer', N'DefaultData', @dir output, 'no_output'
if (@rc = 0) SELECT @dir = @dir + N''
END
IF (@dir IS NULL)
BEGIN
EXEC @rc = [master].[dbo].[xp_instance_regread] N'HKEY_LOCAL_MACHINE', N'SoftwareMicrosoftMSSQLServerSetup', N'SQLDataRoot', @dir output, 'no_output'
if (@rc = 0) SELECT @dir = @dir + N'Backup'
END
IF (@dir IS NULL)
BEGIN
SELECT @dir = N'$(DefaultDataPath)'
END
SELECT @fn = @dir + N'$(DatabaseName)' + N'-' +
CONVERT(nchar(8), GETDATE(), 112) + N'-' +
RIGHT(N'0' + RTRIM(CONVERT(nchar(2), DATEPART(hh, GETDATE()))), 2) +
RIGHT(N'0' + RTRIM(CONVERT(nchar(2), DATEPART(mi, getdate()))), 2) +
RIGHT(N'0' + RTRIM(CONVERT(nchar(2), DATEPART(ss, getdate()))), 2) +
N'.bak'
BACKUP DATABASE [$(DatabaseName)] TO DISK = @fn
END
GO
As you can see above, the destination for the backups is determined by the registry values which store the default backup location for the target SQL Server.
answered Feb 3 '14 at 22:30
Scott HerbertScott Herbert
386413
386413
add a comment |
add a comment |
Thanks for contributing an answer to Server Fault!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fserverfault.com%2fquestions%2f516708%2fwhere-does-sqlpackage-exe-store-database-backups%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown