Backing Up All Target Servers
Aug 7, 2000Has anyone created a script that, when run against the Master database, will back up all databases on target servers?
Thanks
ADVERTISEMENT
Backing Up Logins And Permissions For SQL Servers
May 31, 2006Hi,I work as an IT Administrator and part of my job role is to useEnterprise Manager and Query Analyzer to backup the logins andpermissions for each database on our SQL Servers. This information isused as a backup in the event of a server failing so we then havesomething to fall back on if we need to add the same logins/permissionsagain.This takes ages to do, as I have to manually enter all the informationinto a spreadsheet.Steps:- In Enterprise Manager I connect to a server then 'Security' tab, then'Logins'. I then enter all items into a spreadsheet.- In Query Analyzer I connect to a server then do 'sp_helpuser' to listall the permissions for each database. I then enter all informationinto a spreadsheet.I was wondering if there is such a program available on the market thatwould do this for me? I know that MS Baseline Security can show flatfile share permissions to a certain degree and was wondering if therewas a similar program out there to help me do my job easier, or ifthere is a simple way of doing this in the future...Any feedback would be greatly appreciated.Regards,Jenny
View 2 Replies View RelatedSQL Server Admin 2014 :: How To List The Target Servers Associated With A Master Server
Sep 9, 2015I'm looking for a way to list the target servers associated with a master server. The reason is that we're moving to another master server, and I'd prefer not to move the targets manually.
I've got most of the T-SQL already (sp_msx_enlist, sp_add_jobserver), but I'd like a scripted solution instead of a wizard.
Sql Report Works Fine On Internal Servers - Hosed On External Servers - Need Some Help
Nov 21, 2007I have a report that was designed using SQL Reporting Services that sits on a SQL reporting server. It's nothing too exciting, it is essentially a three page application with legal jumbo on pages 2 and 3 and applicant data in fields on page 1.
We use rectangles to force page breaks to page 2 and to page 3.
When running the report on the report server, it shows and prints fine.
When running the report from the QA website internally, it shows and prints just fine.
When running the report from the production website from a machine internally, it shows and prints just fine.
When running the report from outside of the company network, the report is jacked. It obliterates large chunks of text, crams text together, and creates blank pages.
I need help in determining where I even begin with trouble shooting this!
Development Servers, Auto-update Live Servers
Aug 21, 2001can anyone tell me if they know of a way to automate the update process from development servers to live server, with little interference from an administrator
I have a development team that are constantly updating their databases along with their ASP code, and want to publish changes an a weekly basis. They have asked me for a way to take their new structures, tables, procedures etc, and copy them to the live servers, but NOT to interfere with existing customer data.
Funny I know – and I hate the idea btw :(
Any references, contacts, 3rd party tool recommendations welcome,
Thanx,
Darren
Linking SQL 2005 Servers To SQL 2000 Servers Problems
Sep 27, 2007I am in the middle of a major migraton project, moving from x86 SQL 2000 to IA64 SQL 2005. I have a business need to link to several legacy servers. I have a number of problems I am trying to solve.
1) Linking a Kerberos server to a non-Kerberos server.
2) Linking x64 or IA64 servers to x86 servers.
3) Linking SQL 2005 to SQL 2000.
Two of the errors I am encountering are:
------------------------------
TCP Provider: An existing connection was forcibly closed by the remote host.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
OLE DB provider "SQLNCLI" for linked server "SCDC250DB" returned message "Communication link failure".
(Microsoft SQL Server, Error: 10054)
------------------------------
And
------------------------------
The OLE DB provider "SQLNCLI" for the linked server "SCDC250DB" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "SCDC250DB".
OLE DB provider "SQLCLI" for linked server "SCDC250DB" returned message "Invalid authorization specification".
(Microsoft SQL Server, Error: 7399)
If someone has worked through these problems before, I would appreciate it if you could direct me to the relevant documentation to resolve these issues.
Thanks!
Brandon Forest
Database Administrator
Data & Web Services Team
Sutter Connect Information Technologyforesb@sutterhealth.org
Backing Up SQL DB
Aug 15, 2006We're trying to create a .bak file to send it to our site's admin to restore it on the
server:
1. When I try to do that get this error:http://www.radiorient.net/errors/export_sql.gif
Why is that? and how can I fix it?
2. Should we add both files of the db (.MDF, and .LDF) or only the .MDF file?
Can please someone help me with this, Thanx.
Backing Up A MDF
Nov 10, 2007I plan on using a database file for my site, how would I back it up if I were to make changes to my site?
View 5 Replies View RelatedBACKING UP SQL 7.0
Sep 2, 1999I just got SQL 7.0 and was curious how other environments run their backup. I know ArcServe has a product that backs up open SQL databases and not sure how reliable this product was. Any thoughts would be appreciated .. thanks.
View 3 Replies View RelatedBacking Up MS SQL?
Jul 20, 2005HiI'm hoping that some could point me in the right direction for "bestpractice" in:1) securely backing up a complete sql7 and 2000 server containing manydatabases.2) backing up an individual database3) Securing the transaction on the hour as a mile stone to return to in theevent of error or system failure.ThanksMark
View 5 Replies View RelatedBacking Up
May 20, 2007I always do a quick backup of my project using Developer's Backup before proceeding.
View 1 Replies View RelatedBacking Up Sql Server
Oct 4, 2007Hey, please forgive me if my infomation source was incorrect. But a friend of mine mentioned to me he had hurd of a program, or code that will make an "install script" of your database. Basically it`ll back up all the tables on your server and if the worst case senario happens then you can run the file like an install script. Is this true? It sounds invalueable! If it isnt true, can someone tell me if it is possible to use code to create a "install script" of your own database? I am using "Microsoft SQL Server".Thanks in advance John
View 3 Replies View RelatedPlease Help....backing Up Trn Logs
Aug 26, 2002Scenario:
I have August22 full backup and August22 and August23 transactions log backups . I want to get the August23 and August23 full backup. So I performed a restore backup with August22 full backup and all the August22 trn backups. Then I backed up giving it August23 name and repeated the process with the August23 trn backups. But, I get an error saying that the transactions haven't been rolled foward far enough. But, I am not missing any trns! I will really be grateful if anyone would help.
thanks.
Backing Up DTS Packages
Jul 13, 2000Does anyone know how we can backup DTS packages?
View 2 Replies View RelatedBacking Up On A Different Machine
Aug 7, 2000Hi,
i want to take a backup a database which is on a different machine to my machine.Iam trying to give unc naming conventions i.e backup to //servername/sharename/file.bak but its not working.iam getting an error saying device error or device offline-access denied.
Anyone could tell me how to do it step by step plz.
Thanks.
Backing Up A Database In SQL 7.0
Mar 3, 2000When backing up a database in MS SQL 7.0, there is a window that appears in the destination section of the backup window. In this window is where the filename appears that the backup will proceed to and to the right of this window are "add", "remove" and "contents" buttons.
If there are multiple names in this window, will the entire backup go to both files or does it split the backup between the two filenames.
Backing Up DTS Packages
Mar 12, 2001TO backup a DTS package, does backing up MSDB take care of this or do the files need to be individually backed up?
View 1 Replies View RelatedBacking Up Tables
Mar 10, 2004I use SQL Server 2000 and I create scripts on a daily basis to do the following
1. Rename a table
2. Create table with original name and add new field
3. Copy data from renamed table to new table
4. Build indexes
-----------------------------------------
execute sp_rename ORIGINAL, OLD
GO
CREATE TABLE [dbo].[ORIGINAL] (
[A] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[B] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[C] [int] NOT NULL ,
[Notes] [text] COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
INSERT INTO ORIGINAL (A, B, NOTES)
SELECT A, B, NOTES
FROM OLD
CREATE CLUSTERED INDEX [ORIGINAL_A_B] ON [dbo].[ORIGINAL]([A], [B] DESC ) WITH FILLFACTOR = 90 ON [PRIMARY]
GO
-----------------------------------------
ON A TABLE WITH 100,000 RECORDS THIS KIND OF SCRIPT TAKES A LONG TIME TO DO THE INSERT/SELECT PART
I WOULD USE ALTER/ADD TO UPDATE THE TABLES, BUT MY SUPERIOR INSISTS THAT NOT HAVING TEXT FIELDS AS THE LAST FIELD IN THE TABLE WILL CAUSE QUERKY PROBLEMS WITH HIS SQL STATEMENTS
DOES ANYONE HAVE ANY KNOWLEDGE THAT THIS COULD BE TRUE?
IF SO,
DOES ANYONE HAVE ANY IDEAS FOR DOING THIS SAME PROCESS TO ADD A NEW FIELD (C) BEFORE THE FINAL FIELD (NOTES - TEXT FIELD), AND BACKUP THE TABLE BUT WITHOUT IT TAKING SUCH A LONG TIME ON THE INSERT/SELECT PART?
Forgive me if I'm asking a lot, but I'm lost and these scripts take way too long for what seems like such a simple task.
Thanks,
Mitch
Backing Up Database
May 6, 2004Here is the situation, I have a web application (asp.net/vb.net) with ms sql 2000 as the database. I have two database server. I would like to backup database 1 with database 2. I would like to do it at intervals and through code. If anyone can give me some ideas on how to do this or any research material, please do.
Thanks
Backing Up Database
Feb 20, 2007Sorry this is so trivial, but I don't work with SQL Server too much. I just want to back up a table in one of my databases. I'm using SQL Server 2005, the management studio. Can someone walk me through how to back up a table? Thanks!
View 1 Replies View RelatedBacking Up SQL Server
Apr 19, 2007Hi,
I've recently created a maintenance plan, which backs up my database and transaction log. However I also have a Veritas (Backup Exec for Windows Servers) tape backup which runs at night and backs up my files. It is setup to backup the whole of my MSSQL DATA and BACKUP folders.
Today I went to do a test restore, and found that the tape backup contained nothing in the MSSQL DATA folder, but everything that was in the BACKUP folder. Is this because everything in the DATA folder is in an open state? On checking back, the tape backup has never held anything in the DATA folder. Should I be worried by this, or is it what you would expect, and is the SQL backup sufficient?
Thanks for any advice
Colin
Backing Up From .bak File
Jun 25, 2007I got a .bak file from my friend
I want to restore the data base (presently I don’t have any database in my system).
But while I try to restore it
I am getting an error
“
System.Data.SqlClient.SqlError: Directory lookup for the file "D:Microsoft SQL Server 2005mydatabase.mdf" failed with the operating system error 2(The system cannot find the file specified.). (Microsoft.SqlServer.Smo)
�
I have installed Microsoft sql server in a different directory
Not where he is installed
I can successfully restore the back up files of data base on my own system
But not the backup files created from others systems
Backing Up Data
Sep 4, 2007i have an existing database that is very large. i want to split it into different file groups to make the back up faster. how do you split it? thanks
View 5 Replies View RelatedProblems Backing Up SQL DB.
Jun 1, 2007Every time i try to back up a specific DB i get an error saying it cannot backup because the full text catalog is not permitted because itis not online. It does not matter if i try to backup the db throughSQL of my Backup software. here is the sql log.LogJob History (DB File level Backup.Subplan_1)Step ID1ServerServer NameJob NameDB File level Backup.Subplan_1Step NameSubplan_1Duration00:00:01Sql Severity0Sql Message ID0Operator EmailedOperator Net sentOperator PagedRetries Attempted0MessageExecuted as user: DomainUSer. ...ecute Package Utility Version9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. Allrights reserved. Started: 7:07:43 AM Progress: 2007-06-0107:07:44.14 Source: {B6285A6A-0066-416F-AD9F-F31ED5A68F14}Executing query "DECLARE @Guid UNIQUEIDENTIFIER EXECUTEmsdb..sp".: 100% complete End Progress Error: 2007-06-0107:07:44.49 Code: 0xC002F210 Source: Back Up Database (Full)Execute SQL Task Description: Executing the query "BACKUP DATABASE[DBName] FILEGROUP = N'PRIMARY' TO DISK = N'E:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBackupDBName_200706010707.ba k'WITH NOFORMAT, NOINIT, NAME = N'DBName_backup_20070601070744', SKIP,REWIND, NOUNLOAD, STATS = 10 " failed with the following error: "Thebackup of full-text catalog 'ftcat_documentindex' is not permittedbecause it is not online. Check errorlog file for the reason that full-text catalog became offline and . The step failed.
View 1 Replies View RelatedBacking Up Through VS2005
Nov 19, 2006Hi, not sure I have should ask this in here or in the VS forums - but here goes anyway!
My vb app is written using VS2005 with an SQL database. I'm now distributing this to users to use with SQL Express.
It's hard enough explaining to them how to attach the database without going into the backup routines etc!
So what I'd like to do is to have a "backup" button in my app, that backsup the database, trancates the log files & then shrinks the files.
Is this possible?
DB Engine :: Backing Up MDF And LDF
Jul 22, 2015I'm having an ongoing fallout with the Operations team where I work about database backup strategy. Â They use vSphere (VM ware) to backup all the disks on the servers and included in this are the SQL backups. Â Now I don't really trust this because whenever I ask for a restore, which is very infrequently, they give me an mdf/ldf pair. Â To my mind this shows they are just backing up files and although these files can be re-attached this is not safe, as they were open when the backup was taken. Â Â What I would like to do is use native (or RedGate) backup to create a full backup and have the vSphere pick up the .BAK files.Â
View 14 Replies View RelatedBacking Up DB && Its Permissions
Sep 12, 2007HI All,
I am currently in a situation where I have been fed to the wolves to say the least.
My task is to take the current SQL server 05 we have running on a drive array partioned as C & D and rebuild it.
I need to have the current database backed up, as well as the unique permissions that are currently present on the database.
I then have to remove the hard drives from the RAID array, and replace them with Brand new ones. The OS will then have to be reinstalled, followed by the nessary updates and finally with SQL server.
I then have to import the database back to the new server build w/ the data and the permissions all intact.
Anyone have any idea of how I can go about doing this?
Steve
SET TARGET = NULL
May 2, 2007Hi,
I am writing an insert stamenet that appears like:
INSERT INTO SppTarget (IndicatorNumber, Part, Years, Target, CompareMethod)
SELECT '8', 'B', '20052006', '0.682', '1' UNION ALL
SELECT '8', 'B', '20062007', '0.688', '1' UNION ALL
SELECT '8', 'B', '20072008', '0.692', '1'
What if I want to SET Target = NULL in this statement, how can i do that?
Thanks in advance !
MSX Setup: Cannot See Target DBs?
Aug 15, 2007Hi All
I have set up a MSX server for managing all of our backup jobs. However when I try and create a DB maintenence plan I can only see the system DBs not user created ones!
Is there anything I should do?
Thanks
Gopher
Backing Up Stored Procedures
Mar 7, 2007Is there an easy simple way to backup all my personal Stored Procedures.
In the stored procedures collection, my stored procedures start with "DEF".
I would like to have the stored procedures places as text files in a personal backup folder.
Is this possible?
Copying/ Backing Up A Database
Apr 24, 2005Hi. im shortly going to have to submit my project for uni which ive created using sql server. How can i copy everything that ive made so i can submit everything and it can be replicated if necessary. Do i use the backup database task in enterprise manager or do i have to do that and export data or..?
ive used tables and stored procedures and a diagram btw.
thanks for any advice
Backing Up Databases 2 ---HELP HELP!! URGENT!!
Nov 9, 2000I used sp_detach_db to back up the database temporarily. I used xp_cmdshell
to stop SQLServerAgent, but when I restarted, I was unable to. Then, I tried
reattaching the Database running sp_attach_db.
!!!HELP HELP!!!
I AM GETTING THE FOLLOWING ERROR:
Server: Msg 5105, Level 16, State 4, Line 1
Device activation error. The physical file name
'Mssql7dataTestDB.mdf' may be incorrect.
I KNOW THAT THE NAME AND THE PATH ARE CORRECT.
Really Appreciate the Help
Shelly
Backing Up And Restoring Database
Oct 19, 2000Hi, I am in a production database server. Data has been added and deleted via the web. So there is alot of traffice in and out of the database. How can I make a backup plan to make sure I am not lossing any input or deleted data . I am familiar with backing up a database in regular intervals, but I amnot sure if this is the best way in this senario.
How can I take advantage of the transaction log in restoring the database.
Thanks
Ahmed