Viewing 15 posts - 961 through 975 (of 1,079 total)
Double Take is replication software, typicaly used between Live and your DR site.
http://www.doubletake.com/english/solutions/workload-availability/Pages/sql-recovery.aspx
http://blogs.techrepublic.com.com/window-on-windows/?p=103
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 24, 2010 at 10:16 pm
Backup enables you to do recovery 🙂 ( I assume you are referring to restore, and not a db in Recovery mode)
Ok, all jokes aside, backup is: Making a copy...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 22, 2010 at 3:25 am
Please help to write the script for this scenario.
I'm going to do you one better......
Start by doing your own script, post it, and we will assist from there....
No use in...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 22, 2010 at 2:51 am
write a query to select all the applicable data to this client - export to new table in new database, backup the new database.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 22, 2010 at 2:32 am
write a query to select all the applicable data to this client - export to new table in new database, backup the new database.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 22, 2010 at 1:51 am
In 2000 simply use
Select count (*) from sysdatabases --without the . between sys and databases
and not
Select count (*) from sys.databases
Next time dont put sql 2000 questions under the 2008...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 21, 2010 at 9:55 pm
another (not so efficient) method:
SELECT top 1 database_id as DB_COUNT
FROM sys.databases
order by database_id DESC
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 21, 2010 at 5:28 am
SELECT COUNT(name) FROM sys.databases
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 21, 2010 at 5:06 am
Hi Brad, interesting topic, but also very relevant!
As the only DBA in our environment, I have the privilige of running the show myself, and everyone else relying on my advice...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 20, 2010 at 9:25 pm
Similar Topic:
http://www.sqlservercentral.com/Forums/Topic518031-357-1.aspx
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 20, 2010 at 3:25 am
No, it's 2 seperate packages.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 20, 2010 at 3:09 am
Quoted from MSDN -
"<drive>:\Program Files\Microsoft SQL Server\MSSQL10.<instance_name>\MSSQL\Binn\."
I'll assume you are correct then, and also believe it must be in the same directory...but I could be wrong. 😉
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 20, 2010 at 2:01 am
ramu.guggilla (1/20/2010)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 20, 2010 at 1:46 am
Since you didnt provide info on your current backup strategy, have a read through the following and see if it applies.
http://support.microsoft.com/kb/321836
ELSE....(hehe)
provide more information on what and when you backup with...
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 19, 2010 at 6:50 am
hanging spids\agent jobs
failed jobs
hypothetical indexes
disk space
deadlocks
might want to add:
High CPU, Memory and disk utilization....log percentage used....
Change in DB Status (Online -> offline/Single_User etc..)
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
January 19, 2010 at 6:03 am
Viewing 15 posts - 961 through 975 (of 1,079 total)