snapshot backup question
Thu, 2 Oct 2008 11:10:31 +0200
You can perform snapshot backups using either VDI or VSS - SQL Writer. Three
important steps take place in the database snapshot backup process:
1) Freeze the database (flush buffers, stop writting)
2) Perform the actual snapshot (typically takes < 10 seconds)
3) SQL Server resumes normal operation.
The q ...
|
DataBase Mirroring Problem
Thu, 2 Oct 2008 15:48:58 +0800
Hi,
In SQL 2005 DataBase Mirroring ,
Because the *.ldf is too large.
Can I directly do 'Backup Log ...' and 'DBCC SHRINKFILE ... '
in Principal ?
Thanks.
Bill
...
|
How do I prevent an Owner Change of Maintenance Plan when editing it?
Thu, 2 Oct 2008 00:02:16 -0700 (PDT)
Hello,
every time I edit a maintenance plan the owner changes to my current
windows login. Often I forget about this and the job does not run,
because the SQL-Server services are configured to run with a local
server account and thus a job owned by a domain account cannot be
authenticated and does not run.
...
|
Bulk insert and tempdb
Wed, 01 Oct 2008 23:13:35 -0700
Does anybody know how to stop 'Bulk Insert' from using the tempdb ?
I am trying to rebuild a table using input from bcp.
The table has an identity column which is also the primary key and no
other indexes.
The data in the input file is sorted on the primary key.
I am using the following code for the bulk in ...
|
Rebuid indexes based on the logical frag Script
Wed, 1 Oct 2008 22:44:00 -0700
Hi there,
Is there anyone can provide me a script to rebuild the indexes based on the
certain percentages of logical fragmentation ?
I have a database consists of tables belong to different schemas (owners).
The script provided in the SQL books online does not work because that one
only for all tables b ...
|
How to link servers securely
Wed, 1 Oct 2008 21:07:18 -0700 (PDT)
Hello,
I would like to setup a linked servers connection on a MS SQL 2005
(Express) to a MS SQL 2000 system and its not clear to me how to do it
securely. I have it working fine except I am embedding name/password
in clear text in the commands. I want to link the servers so that I
can periodically download ...
|
sp_updatestats sql2005
Wed, 1 Oct 2008 21:18:28 -0400
When I run this against some of my databases I see
wa_
type indexes not updated.
Are these from people doing ad-hoc queries where no index is used?
How do you clean this up and detect where indexes could be applied. There
are a lot of tables where users just connect with Access and run queries.
...
|
|
|
Creating a Drop down list in SQL express
Wed, 01 Oct 2008 22:04:33 GMT
Can someone please help me with following problem.
I have created a Sql table in SQl express but I want to create a drop down
list directly in one of the columns in the sql database so that I can see the
drop down list when I load my c# datagrid. Whats the best way of going about
this.
Thanks for any help. ...
|
Why should the Pagefilesize be greater than (RAMsize×1.01) with MSSQL??
Wed, 01 Oct 2008 23:59:05 +0200
See Subject and http://support.microsoft.com/kb/889654 (How to determine
the appropriate page file size for 64-bit versions of Windows Server
2003 or Windows XP)
I have a system equipped with 64GiB of RAM.
Why does does SQL and MSDTC require this configuration? RAM sizes are
increasing nowadays and the art ...
|
Transaction Log File size is too big
Wed, 1 Oct 2008 14:29:18 -0400
Sql Server 2005
Recovery model Full
Need to shrink the transaction log file size...
What are the proper steps to do this ?
Can you do this while the database is being used by users ?
Can you create a maintenance plan that will automatically ensure that the
transaction log file size does not get out of ...
|
