Showing posts with label mode. Show all posts
Showing posts with label mode. Show all posts

Friday, March 30, 2012

Newbie Question on DB Maintenance Plan

New to SQL Server. Running SQL Server 2000.

If a database is set to full recovery mode, and in setting up a
database maintenance plan you specify a database backup, why in the
wizard is the question asked if you want to back up the transaction
log?

In a db designated full recovery mode wouldn't that be automatic when
taking a backup?

Thanks in advance.

GerryDataPro wrote:

Quote:

Originally Posted by

New to SQL Server. Running SQL Server 2000.
>
If a database is set to full recovery mode, and in setting up a
database maintenance plan you specify a database backup, why in the
wizard is the question asked if you want to back up the transaction
log?
>
In a db designated full recovery mode wouldn't that be automatic when
taking a backup?


I guess the wizard doesn't force you to use the options sensibly. :)|||

Quote:

Originally Posted by

>
I guess the wizard doesn't force you to use the options sensibly. :)


So I'm to assume that its doing a transaction log backup?|||DataPro (datapro01@.yahoo.com) writes:

Quote:

Originally Posted by

If a database is set to full recovery mode, and in setting up a
database maintenance plan you specify a database backup, why in the
wizard is the question asked if you want to back up the transaction
log?
>
In a db designated full recovery mode wouldn't that be automatic when
taking a backup?


No, you back up the transaction log independetly from the database.
It's a common mistake to run in full recovery but fail to take
transaction log backup. This leads to that the log keeps growing.

On the other hand, if you run simple recovery, you get forget all
about the transaction log.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Yes I was able to finally glean that from looking through a number of
manuals. Makes sense.....I guess it also makes sense not to assume
anything about SQL Server :)

Thanks much for the help.

Gerry

Erland Sommarskog wrote:

Quote:

Originally Posted by

DataPro (datapro01@.yahoo.com) writes:

Quote:

Originally Posted by

If a database is set to full recovery mode, and in setting up a
database maintenance plan you specify a database backup, why in the
wizard is the question asked if you want to back up the transaction
log?

In a db designated full recovery mode wouldn't that be automatic when
taking a backup?


>
No, you back up the transaction log independetly from the database.
It's a common mistake to run in full recovery but fail to take
transaction log backup. This leads to that the log keeps growing.
>
On the other hand, if you run simple recovery, you get forget all
about the transaction log.
>
>
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
>
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

|||"DataPro" <datapro01@.yahoo.comwrote in message
news:1158252255.146201.93870@.h48g2000cwc.googlegro ups.com...

Quote:

Originally Posted by

New to SQL Server. Running SQL Server 2000.
>
If a database is set to full recovery mode, and in setting up a
database maintenance plan you specify a database backup, why in the
wizard is the question asked if you want to back up the transaction
log?
>


Because you may want to run that at separate times.

For example, I do a full backup 3 nights a week and transaction log backups
every 20 minutes.

Quote:

Originally Posted by

In a db designated full recovery mode wouldn't that be automatic when
taking a backup?


No.

Quote:

Originally Posted by

>
Thanks in advance.
>
Gerry
>

|||"DataPro" <datapro01@.yahoo.comwrote in message
news:1158255303.861188.53230@.d34g2000cwd.googlegro ups.com...

Quote:

Originally Posted by

>

Quote:

Originally Posted by

>>
>I guess the wizard doesn't force you to use the options sensibly. :)


>
So I'm to assume that its doing a transaction log backup?
>


Not unless you checked the box.

Monday, March 26, 2012

Newbie Question

Hi
1. Is it possible to chage the authentication mode of the sa for one
database only
2. How do you do that anyway (for all databases in one server)
thanks
Samnope, the login autentication is for server access, after that, there is the
database user to authorize or not ascess to a specific database.
what you can do, is to create a new instance of sql server with just the spe
cific database tha you wanna manage.
"S Shulman" wrote:

> Hi
> 1. Is it possible to chage the authentication mode of the sa for one
> database only
> 2. How do you do that anyway (for all databases in one server)
> thanks
> Sam
>
>

Monday, March 19, 2012

Newbie needing help ASAP with width issue in sql report.

I am building a Sql Report in VS.net 2006 I have run into an issue I have 258 colums it am using the wizard table generator in design mode. the problem is the screen will on allow 160 inches wide I need to mak this larger to 300 inches the purpose of the report is to sort data and them save to csv format is there a better way or can some on tell me how to increase the size of the width the properties tab will not allow me to explain pass 160 inches. Some one please help me thanksWhy not tackle the job another way ? Have a look at http://www.codeproject.com/useritems/filehelpers.asp "An easy to use .NET library to read/write strong typed data from fileswith fixed length or delimited records (CSV). Also has support toimport/export data from different data storages (Excel, Acces,SqlServer, MySql)"|||The issue I am having is a task was given to me to pull data from an invoice module out of SQL and creat a 288 field output of data in a csv format. The problem is we on have about 100 fields data the rest have to be blank and all this has to be in an order so . I was going to build a report in th sql reports in my business intell create the headers for all 288 files and create the expression in the correct placement create several sort paramerters then I was going to just save as csv format this would create the csv file with the correct order and blank fields separated by the commas. the problem is I dont know how to creat empty fields on an output to csv.|||

Suppose your table FRED has three fields A, C and D and you want to output 5, use:

SELECT A, ' ' AS B, C, ' ' AS D, E FROM FRED

That will create 2 empty fields - you can readily extend the technique to create 188 blank fields.

|||

Thank youy this makes sense. The only question is I may need it to look like this

"john", "Smith","","","","","","","404","555-5555","123 Main Street","","completed",

If I under stand the your code I can select A,B,' ' AS C,' ' AS D,' ' AS E, ' ' AS F, ' ' AS G, ' ' AS H,I,J,K,' ' AS L,M FROM TABLE

|||

>>The only question is I may need it to look like this: "john", "Smith","","","","","","","404","555-5555","123 Main Street","","completed",
The quoting takes places aroung each value, whether it is occupied or empty.

>>If I under stand the your code I can select A,B,' ' AS C,' ' AS D,' ' AS E, ' ' AS F, ' ' AS G, ' ' AS H,I,J,K,' ' AS L,M FROM TABLE

Yes! I put a space between the quote marks for clarity; you will not need to do this.

Friday, March 9, 2012

newbie connection problem

I am just starting with MSDE switching from access2002.
The installation was done on a server pc with:
password="sa",
Authentication Mode = SQL, and
DisableNetworkProtocols=0
On the server, I can connect to it fine, both via my app and the configure
wiz'd in the SYSTEM-DSNs list (off of control panel-Admin tools).
But from another PC on a two computer network, I cannot connect to it.
The configure wiz;d gives a double error:
SQLstate 1000 connaction failed ANd
SQLState 8001 error 17: serber does not exist or connection denied.
Do I need to specify anything other than server's name as the server's ID,
e.g. the hard disk label or...?
Do I need to somehow tell the server to allow a conection from another
PC? If yes, I can't find where that might be done?
I'd really appreciate ANY help on this frustrating problem.
Thanks in advance,
Run the program MSSQL\80\Tools\Binn\SVERNTCN and add TCP/IP (or whatever
matches the client side) to the server communication protocol.
|||Run the program MSSQL\80\Tools\Binn\SVERNTCN and add TCP/IP (or whatever
matches the client side) to the server communication protocol.

Saturday, February 25, 2012

newbie - DEBUG MODE?

Hello,
I have a query I'm working on in the Query Analyzer. My query has
variables...I wanted to know if there is a way to track the variable and
see its value (I.e. step through) is there a debug mode in the Query
Analyzer?
Thanks in advance.You can use SQL Debbuger.
From Query Analyzer, right-click on the stored procedure in the Object
Browser and select Debug. That will open SQL Debuuger.
"Fab" wrote:

> Hello,
> I have a query I'm working on in the Query Analyzer. My query has
> variables...I wanted to know if there is a way to track the variable and
> see its value (I.e. step through) is there a debug mode in the Query
> Analyzer?
> Thanks in advance.
>
>|||COOL THANKS JACK!
"Jack" <Jack@.discussions.microsoft.com> wrote in message
news:7BCCA5CF-34FC-44B7-820D-29D35A68F263@.microsoft.com...
> You can use SQL Debbuger.
> From Query Analyzer, right-click on the stored procedure in the Object
> Browser and select Debug. That will open SQL Debuuger.
> "Fab" wrote:
>