Simple script to backup all SQL Server databases
DECLARE @name VARCHAR(50) -- database name DECLARE @path VARCHAR(256) -- path for backup files DECLARE @fileName VARCHAR(256) --...
How to list all the databases on a SQL server
You can list all the databases on a SQL server by running the following query. SQL> select name...
Creating a link between two SQL servers
To create a link between two SQL Servers you need to use the sp_addlinkedserver and sp_addlinkedsrvlogin stored procedures....
Manually adding a mail account to SQL2005/2008
I was having trouble adding configuring Database Mail on a SQL2005 server today. I followed the wizard just...
Simple script to backup all SQL Server databases
[draft] DECLARE @name VARCHAR(50) — database name DECLARE @path VARCHAR(256) — path for backup files DECLARE @fileName VARCHAR(256)...
How to list all the databases on a SQL server
You can list all the databases on a SQL server by running the following query. SQL> select name...
Show Oracle Database DBID
The database ID or DBID is a unique identification number computed when the database is created. To find out this...
Cross checking oracle ArchiveLogs using RMAN in Oracle 8 and 9
In Oracle 10g you can run the following command to crosscheck and expire any expired archive logs: RMAN>...
RMAN-06172: no autobackup found
While performing disaster recovery I get the error RMAN-06172 as below. RMAN> restore spfile to pfile ‘/oracle/app/oracle/product/10.2.0/db_1/dbs/initARJU.ora’ from...
How do you create Export/Import views
Run the “catexp.sql” as SYS. The file is located in $ORACLE_HOME/rdbms/admin. SQL> @?/rdbms/admin/catexp.sql