DotNetShoutout - Stories tagged with backup

backup

atom rss
2
Shouts
spam Shout it Mute it

Split Backup in SQL Server into Multiple Files
published 465 days, 17 hours, 23 minutes ago posted by eralpereralper 468 days, 19 hours, 20 minutes ago
Friday, February 10, 2012 5:00:19 PM GMT Tuesday, February 07, 2012 3:02:54 PM GMT
Split Backup in SQL Server into Multiple Files In order to split backup in SQL Server into multiple files, database administrators can use T-SQL Backup Database command as well as SQL Server Management Studio Back up Database Ta... (more)
category: Data | clicked: 10 | comment | | source: www.kodyaz.com
tags: SQL Server, SQL, backup
2
Shouts
spam Shout it Mute it

Troubleshoot backup \ restore issues with trace flag 3004 «Vidhya Sagar – Blog
posted by sqlarticlessqlarticles 763 days, 18 minutes ago
Tuesday, April 19, 2011 10:05:39 AM GMT
I faced an issue during restoration of very large db in our development database \ server. Issue is restoration takes very long time even though we had latest hardware and recent version of SQL Server (it's SQL 2008 Ent. Ed). So to troubleshoot it I have used the trace flag 3004 which print all internal things happen during backup and restoration operation. (more)
category: Data | clicked: 0 | comment | | source: sql-articles.com
tags: 3004, restore, backup, trace flag, sqlarticles, backup and restore
3
Shouts
spam Shout it Mute it

How Much Memory is Needed \ Taken for My Database Backup
published 764 days, 22 hours, 17 minutes ago posted by sqlarticlessqlarticles 766 days, 23 hours, 30 minutes ago
Sunday, April 17, 2011 12:05:53 PM GMT Friday, April 15, 2011 10:53:11 AM GMT
In this article I will try and cover the concepts in understanding the amount of memory or buffers required for completing a database backup. I would be using a couple of trace flags to get that detail and further discuss two of the parameters MAXTRANSFERSIZE and BUFFERCOUNT in the BACKUP DATABASE – TSQL syntax which will help us understand... (more)
category: Data | clicked: 0 | comment | | source: sql-articles.com
tags: buffer, backup, sqlarticles, memory
4
Shouts
spam Shout it Mute it

SharePoint Backup Using PowerShell
published 811 days, 21 hours, 30 minutes ago posted by JudoJudo 813 days, 5 hours, 40 minutes ago
Tuesday, March 01, 2011 12:53:37 PM GMT Monday, February 28, 2011 4:42:59 AM GMT
PowerShell is a powerful scripting tool that comes as standard in a Windows Server 2008 R2 installation (for prior versions of Windows Server you should manually download and install PowerShell 2 here) PowerShell can be very useful for automating tasks such as backing up SharePoint sites. The below example demostrates a simple backup scenario where PowerShell is used to backup and entire SharePoint site:Open a new text file and enter Backup-SPFarm -Directory D:\Backup -BackupMethod fullSave the file a... (more)
category: UX | clicked: 3 | comment | | source: www.sharepointmonitor.com
tags: sharepoint backup, Powershell, powershell backup, backup
4
Shouts
spam Shout it Mute it

How-to: Quick & Dirty SQL Express scheduled backup
published 823 days, 12 hours, 20 minutes ago posted by https://www.google.com/profiles/dougrathbonehttps://www.google.com/profiles/dougrathbone 826 days, 8 hours, 28 minutes ago
Thursday, February 17, 2011 10:02:52 PM GMT Tuesday, February 15, 2011 1:55:12 AM GMT
SQL Express is pretty awesome as a light weight database server, and when Microsoft released it using the same database engine as the full version they did the world a huge favour. I have seen SQL Express in use on a lot of Virtual Private Servers & development boxes, but in most cases users don’t backup their databases regularly because of the missing scheduled jobs functionality that doesn’t ship in the Express version of Microsoft SQL Server. Like most limitations there is an easy way around this. (more)
category: Data | clicked: 0 | comment | | source: www.diaryofaninja.com
tags: sql 2005, SQL 2008, backup
2
Shouts
spam Shout it Mute it

How to Create Full Database Backup on MS SQL Server for a Database using Backup Database command and SqlCmd Utility
posted by eralpereralper 864 days, 23 hours, 18 minutes ago
Friday, January 07, 2011 11:04:50 AM GMT
Below is the t-sql statement which takes a full database backup of a given SQL Server database with database name as a parameter to a given file folder as parameter on the same server or computer. In order to complete the creating a full database sql backup task, we will use the T-SQL BACKUP DATABASE statement. (more)
category: Data | clicked: 0 | comment | | source: www.kodyaz.com
tags: SQL Server, SQL, T-SQL, backup, Database
2
Shouts
spam Shout it Mute it

Zip & FTP database and create backup in sql server : The CodeGain
posted by codegaincodegain 985 days, 4 hours, 7 minutes ago
Thursday, September 09, 2010 6:16:07 AM GMT
Zip & FTP database and create backup in sql server (more)
category: Data | clicked: 0 | comment | | source: www.codegain.com
tags: backup, Database
7
Shouts
spam Shout it Mute it

SQL Azure Backup Using Database Copy | Azure Support
published 993 days, 18 hours, 15 minutes ago posted by JudoJudo 995 days, 2 hours, 36 minutes ago
Tuesday, August 31, 2010 4:08:28 PM GMT Monday, August 30, 2010 7:46:47 AM GMT
Backup is currently a major gap in the SQL Azure product, but with support for Database Copy TSQL command has given at least one option for directly backing up a SQL Azure database by copying a source Azure database to a newly created  Azure database. The TSQL command structure below provides will produce a copy of a database:CREATE DATABASE databasedestinationname AS COPY OF [sourceservername.]databasesourcename Note that this TSQL syntax allows for copying to a different Azure server. This... (more)
category: Architecture | clicked: 1 | comment | | source: www.azuresupport.com
tags: backup, SQL Azure
3
Shouts
spam Shout it Mute it

Schedule a daily backup with SQL Server Express
published 1010 days, 3 minutes ago posted by http://outcoldman.ru/openidhttp://outcoldman.ru/openid 1010 days, 19 hours, 19 minutes ago
Sunday, August 15, 2010 10:20:17 AM GMT Saturday, August 14, 2010 3:04:37 PM GMT
As you know MS SQL Server Express Edition hasn’t Agent Service, which can be used to schedule daily backups or other periodic administrative tasks. But you can use for this standard Windows Schedule tool. (more)
category: Data | clicked: 0 | comment | | source: outcoldman.ru
tags: SQL Server, Zip, TSQL, SQL Server Express, backup
9
Shouts
spam Shout it Mute it

Backup of a FILESTREAM database may include garbage files as well - Jacob's Blog
published 1020 days, 22 hours, 43 minutes ago posted by jacobsebastianjacobsebastian 1021 days, 7 hours, 45 minutes ago
Wednesday, August 04, 2010 11:39:56 AM GMT Wednesday, August 04, 2010 2:38:11 AM GMT
This post is based on the observation that the backup of a FILESTREAM database includes garbage files as well. The repro example given in this post demonstrates that (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: backup, SQLServer, FILESTREAM
5
Shouts
spam Shout it Mute it

SQL-Articles - Backup SQL Database to Remote location
posted by sqlarticlessqlarticles 1137 days, 12 hours, 43 minutes ago
Friday, April 09, 2010 9:40:20 PM GMT
Does the title sounds crazy? You might think that this topic is very simple? Yes you are right however some folks still raise this question in forums. I’m seeing this question for for a long time in forums and thought of sharing the solution here, so that the folks can give a search to get this (coz Google is our first techie teacher or instant solu... (more)
category: Data | clicked: 1 | comment | | source: sql-articles.com
tags: sql backup, sql-articles, backup, remote backup
5
Shouts
spam Shout it Mute it

SQL-Articles - Suppress Backup information in Errorlog
published 1141 days, 21 hours, 38 minutes ago posted by sqlarticlessqlarticles 1143 days, 6 hours, 28 minutes ago
Monday, April 05, 2010 12:45:02 PM GMT Sunday, April 04, 2010 3:55:06 AM GMT
After a long gap I’m writing a article. This article is all about suppressing successful backup information into errorlog. Let me explain my scenario, In my working environment we have a production SQL Server with 60+ databases, all the databases are set to full recovery and data loss is accepted only for 15 min. Yeah you got me, we are taking Full... (more)
category: Data | clicked: 0 | comment | | source: sql-articles.com
tags: backup, trace flag, 3226
4
Shouts
spam Shout it Mute it

Schedule database backup for sql server 2005 using maintenance plan
posted by kcherupakcherupa 1173 days, 5 hours, 6 minutes ago
Friday, March 05, 2010 5:16:55 AM GMT
Scheduling a daily backup of sql server 2005 database using sql agent is very easy. By following below steps anyone can do that. Open sql server 2005 Management Studio and connect a serverExpand the tree (left navigation) ”Management->Maintenance Plans”Right click on node Maintenance Plans and Click “Maintenance Plan Wizard” (As shown in figure below) which causes to open a wizard. Follow the wizard In 2nd step of the wizard, You can schedule the task as clicking the Button “Change” as shown i... (more)
category: Data | clicked: 0 | comment | | source: cherupally.blogspot.com
tags: sql agent, recurrent, backup, Database, SQL Server 2005, Daily
5
Shouts
spam Shout it Mute it

SQL Server Backup Compression Software - SQL Backup Compression Tools
published 1172 days, 19 hours, 49 minutes ago posted by eralpereralper 1174 days, 43 minutes ago
Friday, March 05, 2010 2:33:53 PM GMT Thursday, March 04, 2010 9:40:13 AM GMT
SQL Server Backup Compression Software - SQL Backup Compression Tools After the release of Microsoft SQL Server 2008, sql database administrators (DBA's) and sql developers have acquired a new tool for SQL Se... (more)
category: Data | clicked: 1 | comment | | source: www.kodyaz.com
tags: SQL Server, SQL Server 2008 Backup, sql backup, SQL Server 2008, backup, data compression, Compression, backup compression