Database Backup

I am new to SQL Server, is it possible to back-up a database or even
individual tables to a server that does not have SQL Server installed? I
want this to be an automated process so that daily updates to the database
can be pickup by our back-up system that runs on a seperate server.
Thanks
AlexIf I understand your question, "tes". You can backup you SQL DB's to another
box that doesnt have SQL installed.
--
TIA,
ChrisR
"Alex" wrote:

> I am new to SQL Server, is it possible to back-up a database or even
> individual tables to a server that does not have SQL Server installed? I
> want this to be an automated process so that daily updates to the database
> can be pickup by our back-up system that runs on a seperate server.
> Thanks
> Alex|||You can not backup tables directly but any SQL Server backup can be sent to
a remote share or network location as long as the account SQL Server is
using has the permissions to access that share. Always use UNC notion and
not mapped drives.
Andrew J. Kelly SQL MVP
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:3582FBB0-D1C7-42BE-902D-494B35328BCB@.microsoft.com...
>I am new to SQL Server, is it possible to back-up a database or even
> individual tables to a server that does not have SQL Server installed? I
> want this to be an automated process so that daily updates to the database
> can be pickup by our back-up system that runs on a seperate server.
> Thanks
> Alex|||Alex,
Use DTS or BCP (OUT) to copy the data out to a file.
HTH
Jerry
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:3582FBB0-D1C7-42BE-902D-494B35328BCB@.microsoft.com...
>I am new to SQL Server, is it possible to back-up a database or even
> individual tables to a server that does not have SQL Server installed? I
> want this to be an automated process so that daily updates to the database
> can be pickup by our back-up system that runs on a seperate server.
> Thanks
> Alex|||Hi,
You can backup the database using UNC names in the Backup database command.
Prerequsites to do a backup remotely
---
There are Few Pre requisites to do backup remotely;
1. You Should start SQL server using Domain user who got access to remote
machine Share
2. Should have share in the remote machine
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak' with
init
For table wise backup use:- DTS or BCP OUT.
Thanks
Hari
SQL Server MVP
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:3582FBB0-D1C7-42BE-902D-494B35328BCB@.microsoft.com...
>I am new to SQL Server, is it possible to back-up a database or even
> individual tables to a server that does not have SQL Server installed? I
> want this to be an automated process so that daily updates to the database
> can be pickup by our back-up system that runs on a seperate server.
> Thanks
> Alex

Database Backup

I am new to SQL Server, is it possible to back-up a database or even
individual tables to a server that does not have SQL Server installed? I
want this to be an automated process so that daily updates to the database
can be pickup by our back-up system that runs on a seperate server.
Thanks
Alex
If I understand your question, "tes". You can backup you SQL DB's to another
box that doesnt have SQL installed.
TIA,
ChrisR
"Alex" wrote:

> I am new to SQL Server, is it possible to back-up a database or even
> individual tables to a server that does not have SQL Server installed? I
> want this to be an automated process so that daily updates to the database
> can be pickup by our back-up system that runs on a seperate server.
> Thanks
> Alex
|||You can not backup tables directly but any SQL Server backup can be sent to
a remote share or network location as long as the account SQL Server is
using has the permissions to access that share. Always use UNC notion and
not mapped drives.
Andrew J. Kelly SQL MVP
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:3582FBB0-D1C7-42BE-902D-494B35328BCB@.microsoft.com...
>I am new to SQL Server, is it possible to back-up a database or even
> individual tables to a server that does not have SQL Server installed? I
> want this to be an automated process so that daily updates to the database
> can be pickup by our back-up system that runs on a seperate server.
> Thanks
> Alex
|||Alex,
Use DTS or BCP (OUT) to copy the data out to a file.
HTH
Jerry
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:3582FBB0-D1C7-42BE-902D-494B35328BCB@.microsoft.com...
>I am new to SQL Server, is it possible to back-up a database or even
> individual tables to a server that does not have SQL Server installed? I
> want this to be an automated process so that daily updates to the database
> can be pickup by our back-up system that runs on a seperate server.
> Thanks
> Alex
|||Hi,
You can backup the database using UNC names in the Backup database command.
Prerequsites to do a backup remotely
There are Few Pre requisites to do backup remotely;
1. You Should start SQL server using Domain user who got access to remote
machine Share
2. Should have share in the remote machine
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak' with
init
For table wise backup use:- DTS or BCP OUT.
Thanks
Hari
SQL Server MVP
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:3582FBB0-D1C7-42BE-902D-494B35328BCB@.microsoft.com...
>I am new to SQL Server, is it possible to back-up a database or even
> individual tables to a server that does not have SQL Server installed? I
> want this to be an automated process so that daily updates to the database
> can be pickup by our back-up system that runs on a seperate server.
> Thanks
> Alex

Database Backup

I am new to SQL Server, is it possible to back-up a database or even
individual tables to a server that does not have SQL Server installed? I
want this to be an automated process so that daily updates to the database
can be pickup by our back-up system that runs on a seperate server.
Thanks
AlexIf I understand your question, "tes". You can backup you SQL DB's to another
box that doesnt have SQL installed.
--
TIA,
ChrisR
"Alex" wrote:
> I am new to SQL Server, is it possible to back-up a database or even
> individual tables to a server that does not have SQL Server installed? I
> want this to be an automated process so that daily updates to the database
> can be pickup by our back-up system that runs on a seperate server.
> Thanks
> Alex|||You can not backup tables directly but any SQL Server backup can be sent to
a remote share or network location as long as the account SQL Server is
using has the permissions to access that share. Always use UNC notion and
not mapped drives.
--
Andrew J. Kelly SQL MVP
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:3582FBB0-D1C7-42BE-902D-494B35328BCB@.microsoft.com...
>I am new to SQL Server, is it possible to back-up a database or even
> individual tables to a server that does not have SQL Server installed? I
> want this to be an automated process so that daily updates to the database
> can be pickup by our back-up system that runs on a seperate server.
> Thanks
> Alex|||Alex,
Use DTS or BCP (OUT) to copy the data out to a file.
HTH
Jerry
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:3582FBB0-D1C7-42BE-902D-494B35328BCB@.microsoft.com...
>I am new to SQL Server, is it possible to back-up a database or even
> individual tables to a server that does not have SQL Server installed? I
> want this to be an automated process so that daily updates to the database
> can be pickup by our back-up system that runs on a seperate server.
> Thanks
> Alex|||Hi,
You can backup the database using UNC names in the Backup database command.
Prerequsites to do a backup remotely
---
There are Few Pre requisites to do backup remotely;
1. You Should start SQL server using Domain user who got access to remote
machine Share
2. Should have share in the remote machine
3. If you need to schedule this as a job then SQL Agent should use the same
Domain user in which SQL server was started
4. Restart the services
Now you can execute the Backup script with UNC path
BACKUP Database <dbname> to disk='\\computername\sharename\dbname.bak' with
init
For table wise backup use:- DTS or BCP OUT.
Thanks
Hari
SQL Server MVP
"Alex" <Alex@.discussions.microsoft.com> wrote in message
news:3582FBB0-D1C7-42BE-902D-494B35328BCB@.microsoft.com...
>I am new to SQL Server, is it possible to back-up a database or even
> individual tables to a server that does not have SQL Server installed? I
> want this to be an automated process so that daily updates to the database
> can be pickup by our back-up system that runs on a seperate server.
> Thanks
> Alex

Database attach using .mdf and .ldf files

Hi all,
I have a problem with my sharepoint database. I lost access after i
installed SP1 on Sharepoint Portal 2007. When i tried to restore from my
backup sets i've seen that backup files corrupted. I just have mdf and ldf
files of the database. I've searched on this page and also internet but
suggested solutions did not work for me. I tried sp_attach_db and
sp_attach_single_file_db queries but they did not work. I got the same errors
that others who having the same problem. Also i tried to create a database in
the same name and changed the database files with the old ones. Then set the
database in emergency mode and tried to set online again using alter database
command. It is still being executed for 48 hours but havent been
completed.This database is very important for me and i need to get my
database back. So, do you know any alternative methods to get my database
back, just using mdf and ldf files on the same server or on the different
server?Have you tried to use (DBCC) REBUILD_LOG ?
--
Jack Vamvas
___________________________________
Search IT jobs from multiple sources- http://www.ITjobfeed.com
"ALKIM" <ALKIM@.discussions.microsoft.com> wrote in message
news:9A7F69FE-C2CA-40EC-9E37-E8D2178AB3FF@.microsoft.com...
> Hi all,
> I have a problem with my sharepoint database. I lost access after i
> installed SP1 on Sharepoint Portal 2007. When i tried to restore from my
> backup sets i've seen that backup files corrupted. I just have mdf and ldf
> files of the database. I've searched on this page and also internet but
> suggested solutions did not work for me. I tried sp_attach_db and
> sp_attach_single_file_db queries but they did not work. I got the same
> errors
> that others who having the same problem. Also i tried to create a database
> in
> the same name and changed the database files with the old ones. Then set
> the
> database in emergency mode and tried to set online again using alter
> database
> command. It is still being executed for 48 hours but havent been
> completed.This database is very important for me and i need to get my
> database back. So, do you know any alternative methods to get my database
> back, just using mdf and ldf files on the same server or on the different
> server?

Database arhiving...

hello all,
What is the best way to achieve the following mechanism.

My product has a database, which will be installed at my client site.
as we all know database is something which will grow tremendously.
Now i am planning to come out with a Data archiving facility in such a way that
Yearly data will be backed up and will be maintained in a separate machine.
The data that was backed up will be removed from the current machine's database.Ofcourse
there will be a mchanism provided through which i can transfer data from offline database to online database.
Now, please throw u r thoughts on how to approach this problem...
My database is in SQL Server.

Thanks and regards
saiRE: Q1 What is the best way to achieve the following mechanism?
A1 Concisely, the 'best way' is to:
i Find out and understand what the business rules are before you start creating an archival system. (When the BRs are ambiguous or inconsistent, you need to bring that to the attention of the business users so they may resolve any issues so you may create sound and correct logical designs).
ii Create a logical design that reflects what the (logically consistent) business rules are.
iii Review the implications with the users before populating your designs. Test and validate with the business users (correct / redesign as necessary) prior to putting anything into production.

Why is this the best way? Some form of this approach is the only professional way to go about things.
----Example-----

Some example considerations (may or may not be relevant, and is by no means comprehensive). Note F1 - F5 are facts (from the posted information):

F1 A DB will be installed at client site.

F2 The DB will grow tremendously.
--> How often, how much, at what time(s) (of the day month, year, etc.) are there frequent data modifications or are only new records added to amend previous transactions?

On the DB Data archiving facility:

F3 Yearly data will be 'backed up' to a 'near line' (off-line?) machine
--> How often, how much, at what time(s) (of the day month, year, etc.) and how?

F4 Yearly data will be maintained in a 'near line' (off-line?) machine.
--> What kind of access, connectivity exists between the production and 'near line' machines?
--> Must the same schema exist on the 'near line' (off-line?) machine?
--> Is the schema such that it may be expected to change frequently, rarely or never?
--> What do existing BRs imply in relation to schema changes (must historical data be accessible forever, if not how long, if so must multiple systems be maintained, or will conversions be performed with each change)?

F5 Yearly data will be removed from the production machine's DB and a mechanism will be provided to transfer data from 'near line' (off-line?) DB to the online production DB.
--> What are the mechanism's general, and specific requirements (performance, capacity), how often will it be used, how much may it be permitted to degrade production performance, etc.?

Database Admin Security Permissions

Hi,
We installed SQL 2000 Tools only (Enterprise manager) on
the database admins pc's, and now we want to setup
permissions for the database admins to only be able to do
database administration.
Should I use Windows authentication, (how do I setup just
enough permissions?) or SQL Authentication (how do I do
that?) Is there a whitepaper for this? What is the best
practice?
Thanks,
Judith
Hi,
What ever authentication, If you set the SYSTEM ADMIN role to DBA person, he
can do administration as well as any changes to databases .
Why should you restrict access to database administrators? Normally in all
enterprises he is the guy who is responsible
for your datbase server. So no need to protect the access from him
Thanks
Hari
MCDBA
"Judith" <anonymous@.discussions.microsoft.com> wrote in message
news:12b9801c44339$5cf78a20$a401280a@.phx.gbl...
> Hi,
> We installed SQL 2000 Tools only (Enterprise manager) on
> the database admins pc's, and now we want to setup
> permissions for the database admins to only be able to do
> database administration.
> Should I use Windows authentication, (how do I setup just
> enough permissions?) or SQL Authentication (how do I do
> that?) Is there a whitepaper for this? What is the best
> practice?
> Thanks,
> Judith
>
|||Well, I could think of this myself! But the question is
that that I want to restrict access for database admins,
because it's a different department and responsibility. So
our enterprise is a little different. Does anybody knows
more about this subject?
Thanks in advance!!!

>--Original Message--
>Hi,
>What ever authentication, If you set the SYSTEM ADMIN
role to DBA person, he
>can do administration as well as any changes to
databases .
>Why should you restrict access to database
administrators? Normally in all
>enterprises he is the guy who is responsible
>for your datbase server. So no need to protect the access
from him
>Thanks
>Hari
>MCDBA
>
>"Judith" <anonymous@.discussions.microsoft.com> wrote in
message[vbcol=seagreen]
>news:12b9801c44339$5cf78a20$a401280a@.phx.gbl...
do[vbcol=seagreen]
just
>
>.
>

database

Hi,
I have installed MS sql server management Studio Express.
Downloaded the AdventureWorks_Data.mdf
Now would like to have this as a database to use.
Right clicked on databases, Attach, in database to Attach added the path to the .mdf, then clicked OK.
The error message is:
Unable to open the AdventureWorks_Date.mdf
Any thoughts please?
Thanks

solved.

It was to do with security

Data types Differences

I've recently installed a new server for an aplication we used at work. In the old server we had SQL Server 2000; for the new one we bought SQL Server 2005. Everything is ok till now, the aplication has worked ok; all ok except one thing.

I have a report in excel, all the format of the report is saved on one table, that table has fields bit, smallint, tinyint, varchar. Now if I try to make the report all the information is ok but the format it's messed. I think that maybe the application might be interpreting the information wrong. I don't have the sources of the application, so cannot debug it.

If I make the report but on the old server, the report appears ok.

Did something on these types (bit, tinyint,varchar,smallint) change from 2000 to 2005?

What can be happening?

Nothing about these types have changed. You might try running profiler against both servers, comparing the statements sent to the server, and then executing the queries from query analzyer/managment studio. Perhaps the results of the queries used to build the report are different in some respect.

|||

I'm not sure if you're saying that the data is in Excel and you're accessing it from SQL Server or the data is in SQL Server and you're accessing it in Excel.

If the data is in Excel and you're accessing it from SQL Server, you may have an issue based on the way you're doing it. If the data is in SQL Server and you're accessing it from Excel, check the compatibility flag on the database. Was this database upgraded from 2K to 2K5 or is it native 2K5?

Buck

|||

No the data is in SQL Server, the aplication access it and create a report on excel. I installed the SQL Server from zero in the new server but the database came from a SQL Server 2K.

Thank you both for reply.

|||

Then I recommend changing the compatibility setting on the database. Also - ensure that the system with the Excel report has the latest MDAC pack on it.

As an aside, I reccomend that you use a different client than Excel to access SQL Server. Microsoft Office applications can tend to escalate locks unacceptably.

Buck

|||

Mr. Halmans, I've run the profiler in both servers and seems to be the same, there are no differences in the statements or the results.

What about the binary type? Any changes? 'cause the report seems to select and update some binary field on one table.

Mr Woody, I'm not using Excel to extract information from the SQL, one application does the extraction and just use excel to present it, but all the information about the format of the excel cells (size, type, formula, etc) are saved in the data base. Right now the report appears with the right information but with no format at all.