Viewing 15 posts - 1 through 15 (of 1,291 total)
If you plan to uninstall and fresh install, keep in mind you will have to list out plenty of things before you uninstall.
Script out SQL Agent Jobs, Linked Servers,...
February 9, 2012 at 5:09 pm
Agree with the previous users opinions on installing, it would be a better way..
If you are planning to do a in-place upgrade, then I don't think you cannot upgrade 2...
February 9, 2012 at 2:28 pm
Also consider if you are going to have new indexes on one or more columns (may be startdatetime or login name etc)..
February 8, 2012 at 2:35 pm
Good to know, glad to help..
February 8, 2012 at 1:58 pm
You are still seeing only 1 row when you try from your workstation ssms? If so, have you tried closing down ssms and open it afresh..
Since this is not a...
February 8, 2012 at 1:57 pm
Looks like you are storing a trace information in that table..
It is you who has more information than any one..
By that what I would say is, try doing...
February 8, 2012 at 1:47 pm
ahthomas (2/8/2012)
February 8, 2012 at 1:40 pm
From what you explain, I would suggest you to look at Transactional Replication..
February 8, 2012 at 1:39 pm
Then you can try this, run a trace without filtering the application name and run a simple top x query from SSMS. Stop the trace, it should have captured that...
February 8, 2012 at 1:34 pm
vardan.hakopian (2/8/2012)
fileidgroupidsizemaxsizegrowthstatusperfdbidnamefilename111862400-138400208PRDE:\DB_Data\PRD_COPY.mdf
20704000-110104864208PRD_logG:\DB_Log\PRD_COPY_log.LDF
If that returns more than 1 record, it should then display you the same number of rows in database properties (when you select files page)..
Can you ensure you close...
February 8, 2012 at 1:34 pm
vardan.hakopian (2/8/2012)
There is only 1 row for mdf
Run the below script and see what you get..
SELECT * FROM MASTER..SYSALTFILES WHERE dbid = DB_ID('Database_Name')
Replace Database_name with the database that you are...
February 8, 2012 at 1:23 pm
Yes you can..
Explore the following possibilities..
Replication
Log Shipping
Database Mirroring
Though each of them have its own advantages and disadvantages to choose from.. Once you know more about them, you will...
February 8, 2012 at 1:20 pm
SQLback (2/8/2012)
Full and Transactional Log backups are not mutually exclusive. A Log backup can occur when full backup is running.
I have not said that they are mutually exclusive...
It is...
February 8, 2012 at 1:06 pm
At first, I thought the same as Gail mentioned but after looking at the schedule for the 2nd time, I am assuming whoever has created the Maintenance plan and...
February 8, 2012 at 12:41 pm
Looks fine.. Looking at the schedule, I am guessing the database is not a very large database..
All in all I don't see any problems with that schedule..
February 8, 2012 at 12:25 pm
Viewing 15 posts - 1 through 15 (of 1,291 total)