No announcements
Found 779138 threads
-
1 VotesBackup on database
Create a batch file of SQL Server databases backup in a text editor.Answered | 5 Replies | 1335 Views | Created by Kyle Moul - Friday, August 22, 2014 7:46 PM | Last reply by Kyle Moul - Tuesday, August 26, 2014 2:24 PM
-
0 Votes
Scheduling a database backup
How do I log into the database from the SQLCMD?Answered | 12 Replies | 7959 Views | Created by BGPMK - Saturday, April 10, 2010 4:49 PM | Last reply by BGPMK - Wednesday, April 14, 2010 2:56 PM -
1 Votes
Backup Restore Database Server-Station
I reccommend creating a batch file and use the SQLCMD syntax to script the backing up of a database.Answered | 2 Replies | 4173 Views | Created by Joba Diniz - Monday, July 18, 2011 6:15 PM | Last reply by Phil Tyler - Wednesday, July 20, 2011 9:39 AM -
0 Votes
SQL Server Database Instance Backup
I have two instances(WCTEST, WCPROD) in my SQL Database.Answered | 4 Replies | 1030 Views | Created by Bhagirath Kontham - Thursday, September 3, 2015 5:26 PM | Last reply by Shanky_621 - Friday, September 4, 2015 10:16 AM -
0 Votes
BACKUP Detected Corruption in the database log
1) take full back of database 2) Run checkdb on database 3) Backup log with truncate_only options 4) Took again full ...Answered | 5 Replies | 15743 Views | Created by SQLBEE07 - Monday, September 2, 2013 8:58 AM | Last reply by Pradeep Madheshiya Microsoft(MSFT) - Monday, September 2, 2013 1:22 PM -
0 Votes
EDI Batching from Custom Database???
We can use this stored proc to get the BAtch Id exec edi_GetBatchIdForBatchName 'MyBatch' on management database.Answered | 17 Replies | 9809 Views | Created by SPN Biztalk - Tuesday, October 5, 2010 9:53 PM | Last reply by SPN Biztalk - Wednesday, October 13, 2010 9:35 PM -
1 Votes
Backup Database
To get a bit more specific, with SQL Server backups, if you have a database <mydb> with the ...Answered | 12 Replies | 1572 Views | Created by tom_fug - Sunday, April 13, 2014 11:58 AM | Last reply by Kevin Farlee [MSFT] - Tuesday, April 15, 2014 12:09 AM -
0 Votes
database backup
BACKUP DATABASE on disk on key and RESTORE on my local system..Answered | 10 Replies | 6040 Views | Created by Cup Of Life - Wednesday, September 15, 2010 10:10 AM | Last reply by TiborK - Wednesday, September 15, 2010 2:42 PM -
0 Votes
Database backup
BACKUP DATABASE [DBNAME] TO VIRTUAL_DEVICE='{GUID comes here}' WITH SNAPSHOT,BUFFERCOUNT=1,BLOCKSIZE=1024,COPY_ONLY Backups are done with ...Answered | 7 Replies | 2704 Views | Created by Olegas D - Wednesday, March 5, 2014 1:10 PM | Last reply by Olegas D - Wednesday, March 5, 2014 2:54 PM -
0 Votes
database backup
Type the below script in your Query window to take a MS SQL Database FULL Backup - BACKUP DATABASE @DBName TO ...Answered | 4 Replies | 4921 Views | Created by Sumanfbc - Monday, April 4, 2011 8:03 AM | Last reply by vinaypugalia - Monday, April 4, 2011 12:02 PM -
0 Votes
Database backup
Is it possible to perform Database backup for each year ?Answered | 5 Replies | 1000 Views | Created by Born4sqldba - Wednesday, July 1, 2015 6:40 PM | Last reply by Olaf Helper - Thursday, July 2, 2015 6:42 AM -
0 Votes
Database Backup
Or what if the current backup files, but did overwrite your only backup?Answered | 5 Replies | 1055 Views | Created by AngaraKiran - Friday, July 18, 2014 12:57 AM | Last reply by TiborK - Sunday, July 20, 2014 10:46 AM -
0 Votes
backup database
Say you have deleted data on 3rd Feb 2011 12.00pm Restore the most recent backup (full) with no recovery say if you ...Answered | 4 Replies | 6715 Views | Created by DesipmDB - Monday, February 28, 2011 7:38 AM | Last reply by Ramakrishna Elashwarapu - Monday, February 28, 2011 9:50 AM -
0 Votes
The CREATE DATABASE statement must be the only statement in the batch.
I got this error message when I had a "-" in my database name.Answered | 2 Replies | 12113 Views | Created by xbally - Thursday, December 2, 2010 2:41 PM | Last reply by ExtremeBidder - Thursday, September 8, 2011 1:04 AM -
1 Votes
Database Backup
hi all when a full database backup is taken , does it backs up both the data file as well as the transaction log file ?Answered | 7 Replies | 1938 Views | Created by rockercya - Tuesday, August 28, 2012 6:41 AM | Last reply by Olaf Helper - Tuesday, August 28, 2012 7:44 AM -
1 Votes
Database backup and restore with C#.net
Hi, I used the following link for Backup/Restore process.Answered | 9 Replies | 25183 Views | Created by NMohanraja - Monday, October 5, 2009 2:45 PM | Last reply by AniMannava - Wednesday, November 7, 2012 11:24 AM -
0 Votes
database backup
Log backups.Answered | 2 Replies | 7918 Views | Created by badr_alex - Sunday, October 21, 2007 6:45 AM | Last reply by Kevin Farlee [MSFT] - Monday, October 22, 2007 7:06 PM -
0 Votes
How to Backup Database on Database Creation Date?
Start taking full backup daily. what if SQL Server database becomes corrupt just before a the backup day.Answered | 14 Replies | 1437 Views | Created by Taoqir - Wednesday, August 31, 2016 12:36 PM | Last reply by S_NO - Sunday, September 4, 2016 10:47 AM -
0 Votes
Database Backup
From the connection string you are using a User instance of the database file.Answered | 3 Replies | 7142 Views | Created by Adizwrld99 - Thursday, July 1, 2010 5:18 AM | Last reply by G.Wilson - Monday, July 5, 2010 12:10 AM -
1 Votes
Database Backup and copy to Shared drive
Hi there, make sure your database is in full recovery model to allow transaction log backups.Answered | 9 Replies | 5236 Views | Created by Database Junior - Monday, August 5, 2013 1:07 PM | Last reply by Fedor Pustovachenko - Monday, August 5, 2013 8:49 PM - Items 1 to 20 of 779138 Next ›
No announcements
