logo
Tags down

shadow

SQL Server 2008 - how to zip backup files and move to remote server


By : Mike
Date : October 17 2020, 11:12 AM
Hope this helps You can backup databases with SQLBackupAndFTP software. It's a simple UI tool with ability to execute and schedule backup jobs (full, diff and log tran backups). It just compresses backups with embedded archiver or 7-zip and send to a local folder or to a NAS drive or FTP or a to a cloud (Dropbox, Google Drive, Amazon S3). Also there is support forum.
code :


Share : facebook icon twitter icon

How to handle .ndf files while restoring backup files in sql server 2008


By : Vysakh Venugopal
Date : March 29 2020, 07:55 AM
this one helps. You can't have multiple data files at the same file path (obviously...). MESDB.ndf is used for multiple files. Give each file a unique physical path.

How to backup table data only, for move with upgrade SQL Server 2000 --> SQL Server 2008?


By : Deepak S
Date : March 29 2020, 07:55 AM
To fix this issue Here are couple things you can do and all of these have advantages and disadvantages:
Manual scripting and linked servers:
code :
INSERT INTO server2008.databaseName.schemaName.TableName (Col1, Col2, ..., Coln)
SELECT Col1, Col2, ..., Coln
FROM server2000.databaseName.schemaName.TableName
ALTER TABLE MyTable NOCHECK CONSTRAINT FK_Constraint
SET IDENTITY_INSERT tableName ON

-- INSERT STATEMENT HERE

SET IDENTITY_INSERT tableName OFF
ALTER TABLE MyTable CHECK CONSTRAINT FK_Constraint

Migration MSSql Db - from SQL Server 2008 R2 Enterprise backup can restore in SQL Server 2008 R2 Express version


By : user3541781
Date : March 29 2020, 07:55 AM
may help you . First of all, there is no SQL Server Ultimate edition - we have Express, Web, Standard, Enterprise, Developer and that's about it. Your source server is a Developer edition.
But yes - as long as the destination's version (2008 R2) is identical (or newer), you can restore a backup from a source server (here also 2008 R2).

C# SQL Server backup of a remote database to the remote default backup location without direct access to the remote loca


By : Michael
Date : March 29 2020, 07:55 AM
wish helps you TL;DR - I want the server to take a backup not my application because the server is set up to do so and my application won't have access. , Thank you @SeanLange
code :
 private static void WriteBackupSp (Server remoteServer, string dbName, out string storedProcedure)
      {
           var s = "CREATE PROCEDURE [dbo].[ProactiveDBBackup]\n";
           s += "AS\n";
           s += "BEGIN\n";
           s += "SET NOCOUNT ON\n";
           s += "BACKUP DATABASE " + dbName + " TO DISK = \'" + string.Concat (remoteServer.BackupDirectory,@"\", dbName, ".bak") + "\'\n";
           s += "END\n";
           storedProcedure = s;
      }
switch (oldProactiveSql.InstanceName)
           {
                case null:
                     try
                     {
                          WriteBackupSp (srv3, oldProactiveSql.DbName, out var storedProcedure);
                          ConnectionToolsUtility.GenerateSqlConnectionString (oldProactiveSql, out var cs);

                          using (SqlConnection connection = new SqlConnection (cs))
                          {
                               using (SqlCommand command = new SqlCommand (storedProcedure, connection))
                               {
                                    connection.Open ();
                                    command.ExecuteNonQuery ();
                                    connection.Close ();
                               }
                          }
                          var execBackup = "EXEC [dbo].[ProactiveDBBackup]\n";
                          using (SqlConnection connection = new SqlConnection (cs))
                          {
                               using (SqlCommand command = new SqlCommand (execBackup, connection))
                               {
                                    connection.Open ();
                                    command.ExecuteNonQuery ();
                                    connection.Close ();
                               }
                          }
                     }
                     catch (Exception e)
                     {
                          Console.WriteLine(e);
                          Console.WriteLine(e.InnerException.Message);
                          throw;
                     }
                     break;
                default:
                     try { bkpDbFull.SqlBackup(srv2); }
                     catch (Exception e)
                     {
                          Console.WriteLine(e);
                          Console.WriteLine(e.InnerException.Message);
                          throw;
                     }
                     break;
           }

Perl vs. PHP to tar files on a remote server then move them to another remote server


By : umer saleem
Date : March 29 2020, 07:55 AM
seems to work fine Not really. Both will get the job done just as good as the other. The bottleneck of both will be connecting to the remote server.
shadow
Privacy Policy - Terms - Contact Us © bighow.org