backup database
Fri, 3 Oct 2008 16:48:08 -0700
this is the 3rd post asking assistance to a very simple task - how to backup
sql database in a 2003 server environment.
--
calm ...
|
Get a list of all tables and their respective size in MB
Fri, 3 Oct 2008 16:46:35 -0300
How to list all tables of a database and their respective size in MB?
Thanks,
Felipe
...
|
import 6 tables into master table from a sql query script
Fri, 3 Oct 2008 12:30:07 -0700 (PDT)
I have some database tables in the master table on SQL Server
Express. I'm using Visio to document the database. The trouble is 6
tables were added after I linked Sql Server to Visio. I got the 6 new
table definitions in a sql query which compiled. I don't know how to
import it to the master database in SQl ...
|
Maintenance Plan Logging.
Fri, 3 Oct 2008 14:52:25 -0400
I have a SQL 2005 (Enterprise 9.0.3042) cluster that is having problems in
the "Rebuild Index" section of the maintenance plan. So, I turned on logging
to get to the bottom of it, but that section is not logged. Even if I
disable all the other parts it still does not show anything in the log file.
This is no ...
|
Getting Query Plan
Fri, 3 Oct 2008 10:43:01 -0700
I am still on SQL Server 2000
I know how to get Graphical Query Plan in Query Analyzer. I, however, have
lots of queries, I want to write some Transact SQL program to execute
queries and get query plan. How do I do that, what stored procedure I need
to call.
Thanks a lot.
...
|
Reorganizing an Index Locks a Table for Writes
Fri, 3 Oct 2008 18:26:58 +0100
I might have misunderstood, but I had thought that reorganizing an index
wouldn't lock the underlying table, or at least if it did only momentarily.
I recently tried this and the reorganize took 15 minutes and the table was
unwritable throughout this time. Is that to be expected?
If so, the real question is ...
|
SQL2005 is it possible to block access to a single table
Fri, 3 Oct 2008 09:42:25 -0700 (PDT)
Hello, I have a table that I eventually will drop but before I drop
the table, I'd rather just prevent any access to it. I'd like to be
able to catch any stored procs or triggers that are accessing the
table but rather then drop the table right away, then find out there
is some rouge sp that we never caught I'd ...
|
|
|
Un-naming named instance
Fri, 3 Oct 2008 08:44:02 -0700
I have 2005 dev version running side-by-side with 2000 on my machine as a
named instance. Seemed like a good idea at the time, and while some of my
apps worked fine with it, others refuse to connect no matter what Ive tried,
and Im tired of wasting time on it.
I want to stop the 2000 instance (easy enough) ...
|
Instance Backup?
Fri, 3 Oct 2008 10:42:49 -0500
I've just started using many of the 'instance level' features of SQL2008
(like replication). I move my work from office to home and back several
times each week. Is there an (easy) way to move entire 'instances'
(Databases, Security, Replications, ect) of SQL between machines? Thanks
...
|
backup database
Fri, 3 Oct 2008 08:33:02 -0700
Please walk me through the steps to generate a sql database backup in server
2003 environment.
--
calm ...
|