Viewing 15 posts - 16 through 30 (of 62 total)
Yes you can, but you have to give a different name to your restored DB.
RESTORE DATABASE [TEST_restored] FROM DISK = N'K:\TEST.bak' WITH FILE = 1,
MOVE N'modeldev'...
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 15, 2011 at 7:49 am
I had the same problem, so I just added a step to be executed on after any step failure.
This is a TSQL Job step that catches the last job history...
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 15, 2011 at 7:35 am
How did you transfer the DB?
Did you detached and attached or did you restored?
If you used any of those ways to move your DB to another server, then you ...
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 15, 2011 at 7:18 am
Your best way is yo use Database Specification Audits to track your NO DML statements.
You can enable it at a certain time and disable with the job at specified time.
This...
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 15, 2011 at 7:04 am
Make sure that you have the right Oracle Client installed.
I know we had problems because the ORA client was a 32 bit version and the Oracle Instance was an x64.
try...
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 14, 2011 at 3:28 pm
Delete the replication jobs if any and run the sp_subscription_cleanup procedure
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 14, 2011 at 3:22 pm
No sir,
you are pretty much stuck with that solution, unless you want to create another table with the new structure and then do an insert into, but that will take...
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 14, 2011 at 3:16 pm
sysusers Contains one row for each Microsoft Windows user, Windows group, Microsoft SQL Server user, or SQL Server role in the database.
http://msdn.microsoft.com/en-us/library/ms179871.aspx
while syslogins contains the login account.
Having a login does...
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 14, 2011 at 3:01 pm
If you do not want to allow gaps and you know what the gaps are, you can use the "SET IDENTITY_INSERT" statement to insert data into the identity column manually.
Here...
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 14, 2011 at 2:59 pm
The Best way is for you to add a Try Catch statement.
Look at the image below, there is a code intended to fail and show you the line number on...
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 14, 2011 at 2:47 pm
You have to use a trigger to monitor DDL changes on any table.
I used the below trigger to monitor any changes to any tables, including the user who made the...
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 14, 2011 at 2:24 pm
Click on Start --> Run: Type SSMS
if you did install it will open up, or you can get a free version from Microsoft website:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796%5D
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 13, 2011 at 2:00 pm
If you are using a Domain account to run your services,
Follow these steps:
1) Change the password in AD
2) Change the Password on the Node2 Services
3) Force a Failover from Node1...
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 13, 2011 at 1:57 pm
Here is a Trigger that I created and currently use on SQL 2005 and 2008.
It monitors when someone creates a new DB and emails me the information, including the create...
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 13, 2011 at 1:46 pm
First create the user in the database, the issue this statement.
Make them members of database role 'db_datareader'
and grant them access to create views and SP.
They will not have access to...
QUIGROUP- Need a Certified experienced DBA for a project or troubleshooting? Need help with programming, database recovery, performance tuning, ETL, SSRS or developing new databases? Contact us.. 1-786-273-9809
April 13, 2011 at 1:22 pm
Viewing 15 posts - 16 through 30 (of 62 total)